SSRS Report Builder Part 6.9 - Matrix Nested Groups

By Andrew Gould

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching!

Chapters
00:00 Topic List
00:39 Creating a Data Source
02:55 Creating a Dataset
05:06 Creating a Basic Matrix
07:15 Changing the Grouping Fields
08:50 Four Ways to Create a Parent Group
12:04 Creating a Child Group
14:20 Multiple Column Groups
16:23 Controlling Column Headers
18:30 Controlling Row Headers
19:54 Creating a Group Header
24:00 Group Footers and Subtotals
26:23 Column Subtotals
27:56 Grand Total Rows and Columns
31:55 Collapsible Groups

This video explains how to create parent and child groups in both the row and column groups of a matrix in Report Builder. You'll learn four ways to add extra groups to a matrix; how to ensure you can always see the row and column headers; and how to create row and column subtotals and grand totals. The final part of the video shows how to create a collapsible group in a matrix so that you can choose which details you want to see when you run the report.

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more