Here is a simple demonstration of how to add totals and subtotals to a report within SQL Server Reporting Services (SSRS). Adding totals and subtotals is simple, but not very intuitive. So I hope this demo helps.
Adding Totals and Subtotals to a report in Microsoft SQL Server Reporting Services (SSRS).
« Introduction to Transact-SQL (T-SQL) using Microsoft SQL Server
Adding grouping and drill down functionality to a report in SQL Server Reporting Services (SSRS). »
Thank you for the video and especially for sharing your knowledge. This site is a fantastic reference!