SSRS Report Builder Part 12.2 - Drill Through Reports using a Matrix

By Andrew Gould

This video teaches you how to create a matrix that you can click on to drill through to another report to see more details. You'll learn how to create hidden parameters in a report and make those parameters optional. You'll see how to assign an action to the value cell of a matrix and pass multiple values into the parameters of the target report. You'll also learn how to do the same thing for the matrix row and column totals.

00:00 Topic List
00:38 The Example Reports
02:14 Creating the Basic Child Report
05:36 Adding Query Parameters
07:24 Making the Parameters Optional
10:26 Saving the Target Report to the Report Server
11:31 Creating the Parent Matrix
15:44 Creating the Drill Through Action in the Matrix
17:48 Preventing Clicks on Empty Cells
21:37 Adding a Total Column and Drill Through Action
23:30 Adding a Total Row and Drill Through Action
24:28 Adding a Grand Total and Drill Through Action
25:43 Actions and Font Colours
28:34 Hiding Parameters in the Target Report
30:25 Hiding the Target Report in the Web Portal

[davidkovarik]

You have the best SSRS training videos!

[TAIMIUWU]

Please, is it possible to create a drillthrough report with a date range using between startdate and enddate?