If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

steps to add All option in static Choice

Started by sram007, 31 Jan 2011 05:57:33 AM

Previous topic - Next topic

sram007

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

melee

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.

PRIT AMRIT

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