SSRS Report Builder Part 12.3 - Drill Through Reports using Charts

By Andrew Gould

Full SSRS Report Builder Playlist https://youtube.com/playlist?list=PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU

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

Видео SSRS Report Builder Part 12.3 - Drill Through Reports using Charts канала WiseOwlTutorials