How To: Hide a report page based on a prompt

Technote (troubleshooting)


Problem(Abstract)

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.

Steps: (See the attached report specs, for Cognos 8 version 8.2. The report contains a list page and a crosstab page, but displays only one of them depending on the value of a prompt)

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.

Cross Reference information
Segment Product Component Platform Version Edition
Business Analytics Cognos ReportNet ReportNet

Historical Number

1033531

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos 8 Business Intelligence
Report Studio

Software version:

1.1, 8.1, 8.2

Operating system(s):

Windows

Reference #:

1342081

Modified date:

2008-05-27

Translate my page

Machine Translation

Content navigation