IBM Cognos 8 Report Studio Cookbook

Conditional column titles

This recipe is meant to introduce you to the Text source variable property.

There is a crosstab report that shows sales quantity by order method (rows) and months (columns). We need to conditionally show full month names or short names depending on user's selection on the prompt page.

Getting ready

Create a crosstab report with Order Method | Order Method on rows, Time (ship Date) | Month (Ship Date) on columns and Sales fact | Quantity in the intersection.

Create a value prompt on the prompt page with following specification:

• Static choices: Full name, Short name
• Parameter name: choice
• User Interface (UI): Radio button group

How to do it...

1. Go to Conditional Explorer and create a Boolean variable. Call it as Is_FullName and ...