Grouping in SSRS Table Reports

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 Table ReportData Source, and Dataset articles to understand the creation of Data Source, Dataset, and SSRS Table report.

If you observe the below screenshot, It was a normal Table report with Product Name, Color, Sales, and Tax Amount columns.

Repeat Headers on Each Page in SSRS 2014

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

SSRS Grouping in Table Reports 1

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
Add Grouping to Table Reports in SSRS 2014

In this example, We are selecting English Product Category Name as a Parent group for this detailed row.

Add Grouping to Table Reports in SSRS 2014

Click Ok to finish creating Parent Group (English Product Category name). Click on the Preview button to see the report preview

Add Grouping to Table Reports in SSRS 2014

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

Add Grouping to Table Reports in SSRS 2014

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.

Add Grouping to Table Reports in SSRS 2014

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

Add Grouping to Table Reports in SSRS 2014

Click on the Preview button to see the SSRS grouping report preview

Add Grouping to Table Reports in SSRS 2014

Comments are closed.