Select ALL values in Value prompt

[Kid_in_Cognos]

Hi,

I have 2 value prompts in the prompt page. Like 1 is country and 2nd is Distributor.

The user can select single value from the prompt to run the report. Also, He should be able execute the report for all the values by using static choice "ALL" . Can you tell me how can I write the condition for this scenario?

Thanks

[Binway]

I have seen a couple of Options for this.

#This will give you a list where all the values are highlighted
(?ProvState?) in ('Show All') and (1=1) or ([Inventory (query)].[Branch].[Province or state] in (?ProvState?))

#Add into the properties of the lookup box in Static Choices the value All then you can select a single value or the word All
([Inventory (query)].[Branch].[Province or state] = (?ProvState?)) OR 'All' = ?ProvState?

You can also change the query filter to optional in the usage field of the query filter properties, this is typically set to required.
When the prompt page appears, if the user makes no selection then all values are returned.

[mrcool]

you can make the prompt optional and edit the header text of the prompt to 'All'.

[sdf]

so you want to have 'ALL Countries' and 'All Distributors' ?
you said ALL is static choice so im concluding you dont have this as consolidated member in your source.

[Kid_in_Cognos]

Hi ,

Thanks for your replies. Actually mrcool suggestion has done the trick. Sorry ,I made a mistake by saying "All" as a static choise.

Regards