Changing drill targets quickly

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

Assume that a crosstab report has been designed to drill to a target report from an intersection. The drill target report accepts many parameters and their mapping is already done. However, because of some changes in business requirements, the drill from intersection now needs to go to another report that 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 and save it as Report 5.1 -Drill from crosstab intersection as shown in the following screenshot:

Create a drill-through link from the crosstab intersection to a list report and pass multiple values. Save...