Quickly changing drill targets

While the project is in the development stage, many things change. Files are moved, folders are renamed, and sometimes requirements change. This often results in re-work.

Assume that a crosstab report has been designed to drill to a target report from intersection. The drill target report accepts many parameters and their mapping is already done. However, because of some changes in business requirement, the drill from intersection now needs to go to another report. That report is already designed to accept the same parameters; we only need to change the target in the main report.

In this recipe, we will see how to quickly change the target report for a drill-through definition, without the need to map the parameters again.

Getting ready

Create a crosstab report shown as follows and save it as '5.1 Drill from crosstab intersection'.

Create drill-through link from the crosstab intersection to a list report and pass multiple values. This list report can be just a...