Hi All,
BO XI R2 We have any Optional Prompts. I mean in my requirement looks like this for example user passing the parameter like
Start Date and END Date OR WEEK of the YEAR OR MONTH OR Quarter OR YEAR. If user pass Parameter WEEK OF THE YEAR other prompts are null or not valid. we have any option like that. please help me on this.
Regards
Vallabh
Vallabhaneni 
(BOB member since 2005-04-18)
Consider using the “ALL” option on prompts that need to be optional. Basically you will be modifying the LOV for these prompt objects to add an entry for ALL. Then you can define a universe object ALL which returns “ALL”. On your report, for the prompts that could be optional, drag this ALL universe object and join with the prompt with an OR. Basically, your SQL will look like this:
[Object 1 ] = @Prompt(,)
OR
“ALL” = @Prompt(,)
You can set the ALL option as the default option in the prompt LOV.
In order to add the ALL option to the LOV, you will have to edit the LOV SQL on the universe to UNION “ALL” and then check “Do not generate SQL” option.
Also, if you want the ALL option to be the first option in your LOV, add a space in front of it, i.e. " ALL" and the then add this to the end of your LOV SQL: Order by 1. If you do this, remember to change the Universe “ALL” object to " ALL" as well.
Farhan Jaffery (BOB member since 2005-08-27)