Hi Arunraj,
How complex are those Conduct/Close Out reports? Can you create just one report for both of them (with multiple queries, bringing all the required data? You can hide the blocks for Close Out when Close Out is selected in Prompt, and vice-versa, using the "Hide when the following condition is true feature" in the Format Table/Chart/(block) options.
Example: In the table for Conduct data, the formula in Format Table -> Hide when... the formula would be =Userresponse () = "Close Out". And for Close Out, the formula would be =Userresponse () = "Conduct".
Thanks,
Mahboob Mohammed
Yes,
If i am not wrong, then you can go with the optional prompts at report level rather then using the prompts universe level as per the scenario you have mentioned.
As per performance based, optional prompt is not good as compared to Universe level prompt.
Regards...
Add comment