SSRS Report Builder Part 12.3 - Drill Through Reports using Charts

By Andrew Gould Full SSRS Report Builder Playlist    • SSRS Report Builder   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! In this video you'll learn how to create a chart that you can click on to drill through into another report to see more details. You'll learn how to apply actions to the objects in a chart and pass values to hidden parameters of the target report. 00:00 Topic List 00:37 The Example Charts 03:03 Creating the Basic Target Report 05:42 Creating Query Parameters 07:17 Making the Parameters Optional 09:58 Making the Parameters Hidden 11:02 Saving the Target Report to the Report Server 11:48 Creating the Basic Parent Report 13:23 Creating a Basic Column Chart 16:07 Basic Chart Formatting 17:56 Adding a Drill Through Action to a Chart Series 19:30 Creating a Drill Through Pie Chart 22:19 Creating a Chart with Category and Series Groups 25:59 Assigning a Drill Through Action to the Chart 27:19 Adding Tooltips to the Chart 30:27 Changing the Chart Type 31:40 Adding Page Breaks before Each Chart 32:26 Hiding the Target Report in the Web Portal 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