How To: Hide a report page based on a prompt
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.
|Business Analytics||Cognos ReportNet||ReportNet|
More support for:
Cognos 8 Business Intelligence
Software version: 1.1, 8.1, 8.2
Operating system(s): Windows
Reference #: 1342081
Modified date: 27 May 2008