In this article, we will show you how to Add Parent Groups and Child Groups to Tables Reports in SQL Server Reporting Services with an example. Here, we are going to use the below-shown report to explain, Grouping in SSRS Table Reports.
Please refer to Table Report, Data Source, and Dataset articles to understand the creation of Data Source, Dataset, and Table report.
If you observe the below screenshot, It was a normal Table report with Product Name, Color, Sales, and Tax Amount columns.
Grouping in SSRS Table Reports
To add or enable grouping in SSRS, first, go to Row groups pane, and right-click on the Details will open the context menu. From the context, Please select Add Group and then select the Parent Group option as shown in below screenshot
Once you choose the Parent Group option, a new Tablix group window will be opened to configure the grouping in SSRS table report.
- Group By: Here, you have to specify the grouping column name. Either you can select the column name from the drop-down list or else click on the fx button to create an expression.
- Add Group Header: Please check mark this option, If you want to add a header to this group
- Add Group Footer: Please check mark this option, If you’re going to add Footer to this group
In this example, We are selecting English Product Category Name as a Parent group for this detailed row.
Click Ok to finish creating Parent Group (English Product Category name). Click on the Preview button to see the report preview
Now we will show you how to Add Child Group to SSRS table Reports.
First, select the Product Category name in the Row Groups pane, and right-click on it will open the context menu. Please choose Add Group and then select the Child Group option
As we all know, the English Product Sub-Category name is a subgroup of English Product Category Name. So, we are selecting English Product Sub Category Name as a Child group for this row.
Click Ok to finish creating Child Group in SSRS(Product Sub-Category name)
From the below screenshot, You can see the created Row groups under the Row Group pane
Click on the Preview button to see the SSRS grouping report preview
