SQL Server Reporting

There are numerous circumstances when we wish to add a custom function to a SSRS report in order to cater for needs of the customer which exceeds the capability of the built-in functions in SSRS. In these scenarios we will have to write our own functions. In this article I will demonstrate how to add [...]

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 [...]

Introduction One of the most important responsibilities of a database administrator is to make sure that all the databases are backed up across environments managed by them. In my earlier article titled Importance of Database Backups and Recovery Plan I discussed the importance of a good database backup and recovery plan for all the user [...]

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 [...]

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 [...]

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 [...]

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 [...]

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. [...]

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 [...]

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 [...]