Overriding crosstab intersection drill-through definition
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 methods on column, we need to display Order methods and Product lines as columns.
The rows display Month. 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.
Getting ready
Create a new drill-through target that accepts Month and Product line as parameters. We will call it as Drill-3 from now on.
For the main report, we will use the same crosstab report as in the last recipe.
How to do it...
We will start by creating the discontinuous crosstab on the main report. We already have Order method on columns. Drag Product line also on the crosstab, as column. The report will look like this.
Now select the intersection cells under the product line column.
From its Properties, set Define contents...
