SQL Server Reporting Services (SSRS) Tutorial - Reporting Services (SSRS) Part 15 - Matrix

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! By Andrew Gould https://www.wiseowl.co.uk - A matrix in Reporting Services allows you to create basic crosstab or pivot table style reports that you might be familiar with from Excel. This video teaches you how to use a matrix in a report, including how to select fields, how to add row and column totals, how to add multiple grouping levels and how to create multiple aggregates in the same matrix. If you need to create a more flexible, dynamic matrix which works more like a Pivot Table, try this video: https://www.youtube.com/watch?v=vgtVJf21EXU You can download the script to create the Movies database used in this video at the following link: https://www.wiseowl.co.uk/reporting-services/videos/ssrs-basic/matrix/ Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!