Overriding crosstab intersection drill-through definitions

Let us consider an extension of the last recipe. Let us say the users want to see a discontinuous crosstab as main report. Instead of just Order method type as a column, we need to display Order method type and Product line as columns.

The rows display Month. The measure is sales quantity.

The drill-through from the intersection has to go to the appropriate report depending on whether the column is Product line or Order method type.

Getting ready

Create a new drill-through target that accepts Month and Product line as parameters. We will call it Drill-3 from now on.

For the main report, we will use the same crosstab report as in the previous recipe.

How to do it...

In the previous recipe, we saw how to create a drill-through from a crosstab intersection to another report. In this recipe, we want to make it more complex. The drill-through line should be different based on the crosstab column. To complete this recipe perform the following...