Category Archives: SSRS

How to draw a line based upon data values in Dundas Chart – Customizing Dundas Chart using Code Editor (SSRS)

Introduction: Dundas has come up with the adding new abilities to Reporting Services (SSRS) in terms of more featured & customizable controls. Not only they look better with lot of UI options to customize, but also have powerful features which … Continue reading

Posted in SQL Server, SSRS | 4 Comments

Extending SQL Server Reporting Services 2005 with Custom Data Extensions (SSRS)

Custom Data Processing   There are many components of SQL Server reporting services which can be customized as per the requirements & one of them is how data is being fetched/processed. Though, SSRS provides quite a good number of inbuilt data … Continue reading

Posted in SQL Server, SSRS | 11 Comments

Multi-language reports in SSRS (SQL Server Reporting Services)

Introduction In this world of globalization, everyone wants to have projects, reports etc being accessed by users across countries/cultures around the world. And thus one needs to support SSRS reports in multiple languages. Different-2 applications provide multi-lingual support in different-2 … Continue reading

Posted in SQL Server, SSRS | 12 Comments

How to set multiple values as Default Values for a multi-valued parameter (SSRS)

In most of the cases when we deal with parameters in SSRS reports, we provide some default value to those parameter (which can be a textbox, a drop down list etc) so that when users browse the report first time, … Continue reading

Posted in SQL Server, SSRS | 39 Comments

Passing multi-value parameter in stored procedure (SSRS report)

In SSRS reports we can have multi valued paremeters, which means we can select multiple values for that parameter and based on all those selected values result in the report is shown. We can write the SQL query to pass … Continue reading

Posted in SQL Server, SSRS | 296 Comments

Customizing ‘Subtotal’ expression by using Inscope function in Matrix Reports (SSRS)

In SSRS Matrix reports there is an inbuilt functionality to have the Subtotal of columns/row fields depending upon the scope of the group in which subtotal is defined. If it is defined in the scope of any row group it … Continue reading

Posted in SQL Server, SSRS | 90 Comments