Roadmap › SSRS — SQL Server Reporting Services › Module: Building Reports
Lessons in this course (10)
3. Grouping, sorting, totals and page breaks
Basic★ Must knowLesson 3 of 10
- Row groups and column groups (parent/child/adjacent), with group headers/footers for subtotals.
- Group expressions like
=Fields!Region.Value; sorting per group; interactive sort on column headers. - Totals: right-click group → Add Total (Before/After).
- Page breaks between group instances (e.g. one region per page), repeat header rows on each page (
RepeatOnNewPagevia Advanced Mode in the Grouping pane),KeepTogether. - Recursive hierarchy (parent-child data, e.g. org chart) using a group with a recursive parent and
Level()for indentation.