IBM Support

How To: Hide a report page based on a prompt

Technote (troubleshooting)


How to use a page's Render Variable to prevent it from displaying based on a prompt value.

Resolving the problem

If defined, the Render Variable property of a page determines whether or not it will be displayed.

1) Create a prompt, and set its Static Choices variable appropriately.

2) Click on Conditional Explorer in the middle bar, and click Variables. Create a String conditional variable (Expression: ?prompt_name?) and add values based on the Static choices from the prompt in step 1.

3) Select each page that may be hidden, and set the Render Variable property to the variable created in step 2. Place a checkmark beside each value for which the page will be displayed.

If a report page has a Render Variable, the page will not be displayed unless a checked condition is met.

NOTE: The prompt from step 1 can be used to conditionally render additional prompt pages as well. However, if these additional prompt pages contain objects (such as value prompts or lists) that are based on queries that contain filters, make sure to change the Finish button to a Next button on the static choice prompt page.

Document information

More support for: Cognos Business Intelligence
Report Studio

Software version: 10.1, 10.1.1, 10.2, 10.2.1, 10.2.2

Operating system(s): Windows

Reference #: 1342081

Modified date: 19 December 2016

Translate this page: