Home Forums Reporting Services SSRS 2012 Matrix drillthrough multi value parameter question RE: Matrix drillthrough multi value parameter question

  • Couple of things before you set up a drill through report:

    1. Have a second report ready which displays the desired output when you pass parameters like $5,000, $10,000 or the region you want to pass.

    2. Once you have the second report ready, right click on the cells which has the $Amount and goto the action section. You will have options for a drillthrough report.

    3. Once you select the second report from the options, you have to map the second report's parameters with the values you want to pass, i.e the $Amount, Region columns in the first report.

    Now save you work and try the drillthrough action.