Hi Experts,

How can we add Select All option in Value prompt?  We have a case like user will select a country in value prompt ( Single selection). If they want all countries data, then they need to select "All Countries" from prompt. So,I added "All countries" in Static Choices and made the report query filter as  ( ?Parameter? = 'All Countries"  or [Data item] = ?Parameter? ).  This is taking long time to generate the report result in HTML / Excel. How can we rectify it? IS there any other option to add "All Countries". The Prompt is Required and single selection. 

Hi,

why do you want an "all elements" selection in a filter/prompt? Just don't let the user select anything which will result in an unapplied filter = all data. The filter in our query just needs to be optional. Cognos then captures when a filter criteria is selected by the user and will activate the filter automatically.

Thanks Robert , For now i made the report like this way only. Also checking if there is any way to achieve this. 

Ok, got it. In this case I'd suggest the same solution you already tried:

?parameter?='-1' OR [dataItem] = ?parameter?

Did a quick test and it doesn't affect the report performance. Which datasource/databse do you use? Have you tried to write FQD makros instead of abbreviations? (#prompt('parameter';'datatype';'default value')# instead of ?parameter?)