The Cognos Report Toolkit - Conditional drill in crosstab

Check list of all posts

General note about The Cognos Report Toolkit

Report specification:  Relational, DMR, and Cube

Requirement

Make crosstab cell drillable when revenue is greater than 300,000,000

Layout

Step 1 Create a normal crosstab

Step 2 Unlock and then highlight intersection text and then copy it as below

Step 3 Define drill through for right one

Step 4 Create a Boolean variable DrillNeeded

Step 5 Assign DrillNeeded variable to both cell text

Step 6 select DrillNeeded as Yes, make conditional style for none-drillable text Box type “NONE”

Step 7 select DrillNeeded as No, make conditional style for drillable text Box type “NONE”