IBM Cognos 8 Report Studio Cookbook

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

1. We will start by creating the discontinuous crosstab ...