SQL Server Reporting Services (SSRS) Tutorial - Reporting Services (SSRS) Part 19 - Subreports

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 Subreport is simply an entire report nested within another one. It's a simple idea that allows you to separate the different sections of complex reports to make designing and formatting them easier. This video teaches you how to construct separate main reports and subreports, how to add parameters and filters to a subreport to ensure they display the correct data, and, of course, how to insert a subreport into a main report and connect the two reports together. If you're experiencing an error message when you preview your report it could be due to a bug in SSRS 2008 R2 when using shared datasets to populate subreports. See this page for more information: https://www.wiseowl.co.uk/blog/s364/subreport-error-shared-dataset.htm 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/subreports/ 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!