How to set up a condition/filter to open report pages selectively ---- solved !

[Jennyw]

I have a report with multiple pages, would like to run the report based on a value that selected in the prompt page.

example:
if select value A, the report will run page 1 through 7.
if select value B, the report will run page 1, 3, 5,6,7.
how to achieve this goal? 

thanks
Jenny

[BigChris]

Hi Jenny,

In your prompt page, set up your prompt with two static options (A and B), and cal it something like pPages
Set up a variable for your report, called something like varOutputPages. For the scenario you've described, you could then make it a boolean variable, along the lines of:
ParamDisplayValue(?pPages?) = 'A'

You can then set the RenderVariable for the pages of your report to be varOutputPages, and select Yes for all pages for Yes, and only those specific pages for No.

[Jennyw]

Hi Chris-
thanks so much, it worked out beautifully! more than i expected, cuz i have a table of contents page, which listed all the pages with page number, when i select B, the page2 and page 4 disappeared in TOC page accordingly, cool!

thanks a billion!
Jenny

[BigChris]

My pleasure - glad that sorted it for you  ;D

C