Print Page - Default All to DB from cognos prompt

Title: Default All to DB from cognos prompt
Post by: kvchowdary on 11 Nov 2016 06:54:15 AM

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

Title: Re: Default All to DB from cognos prompt
Post by: BigChris on 11 Nov 2016 06:58:53 AM

Just make the prompt optional

Title: Re: Default All to DB from cognos prompt
Post by: kvchowdary on 11 Nov 2016 07:40:28 AM

Hi Bigchris,

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

Title: Re: Default All to DB from cognos prompt
Post by: BigChris on 11 Nov 2016 07:52:49 AM

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

Code Select

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: kvchowdary on 11 Nov 2016 06:54:15 AM