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
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.
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
My pleasure - glad that sorted it for you ;D
C