COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sram007 on 31 Jan 2011 05:57:33 AM

Title: steps to add All option in static Choice
Post by: sram007 on 31 Jan 2011 05:57:33 AM
Hi,
I am having a country Prompt which shows Country Codes such as ( US,UK, SL.IND,) etc. But the user wants another option such as 'ALL'. It means if i select ALL option ,all countries data should be displayed. So that i have added a text ALL in static choice in Use & Display.
can u guys help me with the next steps which i have to do...

whethere i have to create a string variable in coditional explorer?

Thanks in Advance..
Cheers
Dilip
Title: Re: steps to add All option in static Choice
Post by: melee on 31 Jan 2011 10:09:57 AM
That's a good idea, but you may be over-complicating a fairly simple operation. I would set your prompt to optional, and if there's no value picked by the user, it should show all.
Title: Re: steps to add All option in static Choice
Post by: PRIT AMRIT on 31 Jan 2011 08:54:24 PM
if you want to add another value to you Country Prompt i.e. 'All', then what you have done is correct adding 'All' as a static choice.

Now, to make this 'All' value work, your country filter should look like below

?country?='All'
or
[Country]=?country?


Hope it would work for you?

Thanks
P