IBM Cognos 10 Report Studio Cookbook - Second Edition

Conditional column titles

This recipe is meant to introduce you to the Text Source Variable property.

Let's say 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 the user's selection on the prompt page.

Getting ready

Create a crosstab report with Order method / Order method type 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 the following specification:

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

How to do it...

To conditionally show full month names or short names depending ...