18 September 2014

SSRS: Creating Report Group

This is an example how to create report group using SQL Server Reporting Services. Yet using this report sample.

We'll create grouping by Year. Give active focus to a cell in table object. We'll see buttons on the left side for every rows.
Right click on the button of detail session then choose Insert Group.

A dialog form of Grouping and Sorting Properties will be displayed. Set the group name then fill row of expression with field to be grouped (Year field). Then click OK button.
Group header is added above the detail line and footer group is added under. We'll move the row of label columns to the header of group by cut and paste as image below.
Now we see the left button icon is become icon of group.
Delete the empty header row.
Then insert a row above.
Design of row will suit focused row while inserting, lets make the new inserted row background color to be transparent.
Merge Cell by blocking its row, right click and choose menu Merge Cell.
Fill the merged row value with "Tahun: " & Fields!Year.Value and set property of BorderStyle = None
Click preview tab to see the result.

Click here if you like this article.

Related Article:
  1. Installing Business Intelligence SQL Server 2005
  2. Creating Report with SQL Server Reporting (Wizard)
  3. Creating Report with SQL Server Reporting (without wizard) | Part 1
  4. Creating Report with SQL Server Reporting (without wizard) | Part 2
  5. Design Layout Report
  6. Creating Parameter for Filtering
  7. Stored Procedure as Report Data Source
  8. Parameter Data List from Database Query
  9. Creating Report Group
  10. Create Sequence Number Using RowNumber Function
  11. Uploading Report FIle (.rdl) to Report Server
  12. Remove Report Page Break/Page Break 
  13. Query to Generate Subscription List 
  14. Direct Printing to Printer