Hide and Show Fields Based on Prompt Values

Information on hide and show fields based on prompt value can be found on the following URL:

http://www.ibm.com/developerworks/data/library/cognos/page370.html

Open the ZIP with information direct:

http://www.ibm.com/developerworks/apps/download/index.jsp?contentid=465599&filename=conditionally_hiding_and_displaying_items_on_a_report.zip&method=http&locale=

Create filter on Database Object

In this example we have a set of data in a table witch has multiple of rows for each date.

In the Cognos report we want to filter the data for a specific date (or value).

We can solve this by adding a filter on the business view object in the Framework Manager (FM). This filter is a prompt witch pops up on opening the report. Continue reading