SSRS: Nested Groups

Integrating multi-level groups within reports.

Often within reports, a natural hierarchy reveals itself that if grouped properly, provides the user an efficient means for viewing large numbers of records while avoiding repeating values.

To illustrate this feature, I’ll begin with an average report illustrating a company’s store demographics.

1-nested-groupsAs you can see, the first two columns may be grouped where duplicate values exists to avoid repeating their values and provide a cleaner looking report for the user.

I’ll create the first group by selecting the detail row and insert a new group.

2-nested-groupsI’ll configure the group to use the CountryRegion field and select to repeat the group header.

3-nested-groups

Next, I’ll drag the CountryRegion field into the group’s header.

4-nested-groups

Executing the report now shows the Country Region values no longer duplicate, but are displayed once per group of records sharing the same values for that field.

5-nested-groups

To create a second, nested group I’ll repeat the process used to create the first group which provides a multi-level grouping in the designer.

6-nested-groups

Executing the report will show multi-level grouping within the report, records sharing the same Country and State are now grouped together.

7-nested-groups

Download Report
(right-click, Save As)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s