SQL Server 2016 Reporting Services Cookbook

Configuring parameters for drill-through reports

Just as with regular SSRS reports, it is possible to have one mobile report execute a second report, passing parameter values from the source to the target. However, the mechanism for passing parameters is radically different.

In traditional SSRS, you can select a specific value in the report body, and launch the target report with that value. This can be done with Mobile Reports, with the caveat that it should be mapped to a navigator in the target report. Typically it is easiest to map the navigators in the source to the navigators in the target, which is what we'll do with this recipe.

Getting ready

For this recipe, we'll create a new report for the target but will be using Report 06-02, as created ...