Default All to DB from cognos prompt

[kvchowdary]

Hi
I have a requirement to pas the all the parameters to the DB and in my prompt i have a default value as'All'.How can i pass the Default 'All'(If user selected any other i need to pass those parameter)

Thanks

[BigChris]

Just make the prompt optional

[kvchowdary]

Hi Bigchris,

I dont have the value All in DB,that is the static choice in prompt page
Thanks,
Venkat

[BigChris]

Ahh...ok. In that case you want to alter your filter so that it ignores the 'All' option, something like:

Code Select Expand

[YourDataField] in ?Prompt? or ?Prompt? = 'All'