Add Total and Subtotal to SSRS Report

22-01-2019  0 Comment(s)

To explain the steps involved to add Total and Subtotal to SSRS Report, We are going to use  below shown DataSet. Please refer to Embedded Data Source and Dataset articles to understand the steps involved in creating Embedded Data Source, and Dataset that we used for this report. 

SSRS provides you two different approaches to add totals, or subtotals to the SSRS reports. In this example, we will explain one approach and later we will explain the other.
To add totals, and subtotal we need a table or matrix report. We are going to use the below-shown report for this example.

Please refer Table Report, Format Table Report articles to understand the steps involved in creating and formatting Table Report, and refer to Grouping in Table Report article for Grouping techniques. If you observe  the Let me show you the Report Preview. If you observe the below screenshot, it is displaying the data in three levels: Occupation is at Top Level, then Education at Second Level, and Details (Full Name, Hire date, Income, Sales) at third level. Here our task is to add Totals to Both Incomes, and Sales Column at all levels.

Comment Here


No Comments to Show