Wednesday, April 17, 2013

The Cognos Report Toolkit - Conditional drill in crosstab

General note about The Cognos Report Toolkit
Report specification:  Relational, DMR, and Cube


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

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”

No comments:

Post a Comment