IBM Support

How To: Hide a report page based on a prompt

Troubleshooting


Problem

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.

[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Studio","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.2;10.2.1;10.2;10.1.1;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21342081