Hi Gurus,
I have report with 3 prompts Region, Country and Date. I have these prompts in report page itself.
Country prompt(Single Select) is cascade from Region (Multi Select). Country has Auto Submit as YES.
When I am running the report if I select a region in region prompt its cascading the countries in the country prompt, but its refreshing the page and some of the result is displaying in the report before selecting the other prompt values and clicking on the FINISH button.
Here my promblem is I have to select all the prompt values and when I click on FINISH button then only report should show the result.
I don't want to hide the report till the prompts are not null.
Please help me in this regard.
Thanks in advance
Check if your 'Country' prompt is 'Optional'...
Because once User selects values from 'Region' prompt it gives input to your 'Country' prompt.
Hence, if 'Country' prompt is optional it generates the report after Auto submit of 'Region; prompt value.