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 the Table ReportData 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.

Format Fonts and Background of a Textbox 8

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.

Add Parent to Table 1

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.
Tablix window 2

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

Choose the Column Name 3

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

Add SSRS Parent Group to Table Reports Preview 4

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.

Add Child in Table Reports 5

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.

Select SSRS Child Group Column Name 6

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

Table Report Details  7

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

SSRS Grouping in Table Reports Preview 8

Comments are closed.