Hinding Pages according to variable

[jkandy]

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

[BIsrik]

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

[CoginAustin]

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"