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...
Go to Conditional Explorer and create a Boolean variable. Call it as Is_FullName and define it as:
ParamDisplayValue('choice') = 'Full Name'.
Now go to the report page and select <Month> from column titles. Set its Text Source variable to Is_FullName.
From Conditional Explorer, choose Yes condition for the variable. This will allow...
