In this article, we will show you how to Add Parent Groups and Child Groups to Tables Reports in SSRS or 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 the Table Report, Data Source, and Dataset articles to understand the creation of the Data Source, Dataset, and SSRS Table report.
If you observe the below screenshot, It was a normal Table report. And it contains Product Name, Color, Sales, and Tax Amount columns.
Grouping in SSRS Table Reports
To add or enable grouping, go to the Row groups pane, and right-click on the Details to open the context menu. From the context, Please select Add Group and the Parent Group option as shown in the screenshot below.
Once you choose the option, a new Tablix group window will be opened to configure the grouping in the SSRS table report.
- Group By: Here, you have to specify the grouping column name. Either select the column name from the drop-down list or 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.
- Add Group Footer: Please check mark this option, If you’re going to add Footer to this.
In this SSRS table reports 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 groups 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 the 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
