Hi,
I have a situation where based on a single parameter, either of the two prompt pages inturn having 10 parameters each should be produced. I f my option is A then prompt page A should appear.I f my option is B, prompt page B should appear. So in any case only 10 of the 20 parameters excluding teh first deciding single parameter are needed to run the report. How to do this?
Thanks,
Srinivasan
This is a bit old now, but I'm bored waiting for home time, so here's a solution:
With one prompt page, use a radio group, a string variable and a conditional block. Set two static values in the radio group, A and B, and set the auto-submit property to true. Create a String variable which uses the parameter from the radio group to populate two Values, A and B. Attach the Conditional Block to the variable and insert the 10 required prompt controls into Block A and Block B. When run, this should conditionally display the prompts depending on the option selected in the radio group. Finally, make sure the filters are set to Optional in the query to be filtered.