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. 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 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

Add Parent Group to Table 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
Tablix Group By Column 2

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

Row Grouping in Table Reports 3

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

Row Grouping in Table Reports Preview 4

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 Child Group in Table Reports 5

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.

Select 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

Child Grouping in Table Reports 7

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

SSRS Grouping in Table Reports Preview 8

Comments are closed.