SQL Server Reporting

SQL Server Data Mining with Microsoft Office Excel

Data Mining with Microsoft Office Excel Introduction A key issue in data mining is not only generating the results but also interpreting them. Unfortunately it is often difficult to interpret the results of data mining and many users are turning to Excel and its data mining add-in tool. Requirements You will need to have permission […]

Reporting Services 2008 R2: Geospatial Visualization – Part I

Geospatial Visualization is one of the key new features of SQL Server 2008 R2 Reporting Services.SQL Server provided geospatial data with SQL Server 2008 and you may have noticed (or perhaps used) the two geospatial data types in SQL Server 2008 : geometry and geography. This support is further extended with Reporting Services 2008 R2 […]

Data Warehouse Partition Strategies

Microsoft put a great deal of effort into SQL Server 2005 and 2008 to ensure that that the platform it is a real Enterprise class product.  I’m not going to write about all the new features in the OLTP Engine, in this article I will focus on Database Partitioning and provide a real world scenario.  This article will cover the following […]

Tweaks in SQL Server Reporting Services

SQL Server Reporting Services (SSRS) is very valuable tool for developers and users to design and view reports. However, there are few features which are not available directly in SSRS. These features are frequently required features for developers and users. Display Server Name or IP Address in a Report Often users will be mislead with […]

Enhancing Reporting Services with Dundas Reporting Controls

Introduction In SQL Server Reporting Services (SSRS) 2005, you have controls like the Textbox, Table, Matrix and Chart to display data.  In the case of SSRS 2008, you have additional controls like the Gauge and Tablix. Now here comes the million dollar questions – Are you satisfied with the available controls in SSRS?  Do you think that you […]

Using Report Parameters in SQL Server Reporting Services

IntroductionWhen you are using reports, you need to have parameters that narrow down your report for better analysis. You will often see that you need to have more than one parameter, where the second parameter may depend on the first parameter, which many require you to refresh the second parameter depending on the first parameter. […]

Overcoming Software Limitations in Multidimensional Reports

Most medium to large sized businesses have a reporting solution that provides timely financial information in a user-friendly format for sales people, managers and customers. Usually, the “solution” is a dedicated reporting employee who manually queries source databases for statistical data. This paper offers two software specific solutions to overcome limitations exposed in Microsoft SQL […]

Get an Edge with SQL Server 2005 Reporting Services

The ultimate utility of a database lies in presenting the data in different formats to fulfill the information requirements of various users. Microsoft SQL Server 2005 Reporting Services (SSRS) gives nontechnical end users and programmers a server-based reporting platform that will generate any kind of report from any kind of data source for both desktop […]

Optimizing Microsoft SQL Server 2000 Reporting Services: Performance and Access Reports from the Execution Log

About the Series This is the second article of the series, Optimizing Microsoft SQL Server Reporting Services, which appears concurrently with my other series. The primary focus of this series is the introduction of optimization concepts and practices for MSSQL Server Reporting Services (“Reporting Services”). The series is designed to provide hands-on application of the […]

Optimizing Microsoft SQL Server 2000 Reporting Services: Execution Log Reporting: Preparation as a Data Source

What We Will Need to Complete the Series Tutorials To get the most out of the Optimizing MSSQL Server Reporting Services series, we need to have installed Microsoft SQL Server 2000 Reporting Services, together with Microsoft Visual Studio.NET (required to access Report Designer for report creation). Reporting Services ships with MSSQL Server 2000, and many […]