COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: jkandy on 08 Feb 2006 02:38:00 PM

Title: Hinding Pages according to variable
Post by: jkandy on 08 Feb 2006 02:38:00 PM
Hi,
I have 7 pages in my report and would like them to be completely conditional.  Meaning, i'd like to be able, based on a column in the database, to either show or hide the page.  Remember, there good be a time that i would wish to hide 3 pages out of the seven, for example.


Joel
Title: Re: Hinding Pages according to variable
Post by: BIsrik on 12 Feb 2006 04:08:45 AM
i am afraid u can't hide pages..i would think of achieving the same in 1 page as much as possible or club information with respective to pages. Like in case 1 i want to display page1 and page3 and in case 2 i want to display page 2 and page 4 of report design pages. But in the outcome i am showing only two page. So i would think of clubing page1 and page 2 to a single report page and the same with page3 and page4. Then apply conditional formating.

Srik
Title: Re: Hinding Pages according to variable
Post by: CoginAustin on 12 Feb 2006 12:55:22 PM
Actually you can.

Add a repeater
Add your report to this repeater
Add a master detail relationship to the repeater and your report inside the repeater
The Master repeater will figure out if it should display or not
Since you didnt give much information other then "a column"
You would need to just putt a filter on the repeater query that filters out only the pages you need.
Change the repeater to 1 x 1 and do a page break on "a column"