SQL Server Reporting Service (SSRS) Second SSRS data Grouping parent group

SQL Server Reporting Service (SSRS) My first SSRS example uses table for simple data display by default, and sometimes we need to group the list by a field for more intuitive data display. For a clearer explanation, I made a new table (already populated with the data) and a report (which can be used to show the data), and the report appears as shown below, and I'll group by year and region:

First step: Prepare

Remove the id,year and country two columns from the current design environment first, as follows:

Step two: Add to group by country

In design mode, select the drop-down box for the triangle after row groups, click Add Group-->parentgroup,

Select Country in the pop-up box and click OK.

Step three: Add a group by region

Repeat the second step to group the region. After you finish making the page adjustments and then publish, the results are as follows:

Summary: There are usually two groups of grouping methods, the sub-parent grouping method, but the essence is the same. Another thing to say about grouping is that I myself think that SSRS borrows the idea of grouping in SQL so that we can show it in SSRS by organizing simple SQL statements. Grouping with SSRS is easy, but often we need the reporting functionality that is not just limited to this, so welcome to the third SSRS matrix usage of SQL Server Reporting Service (SSRS).

SQL Server Reporting Service (SSRS) Second SSRS data Grouping parent group