IBM Cognos 10 Report Studio Cookbook - Second Edition

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 ...