"All" Option in a Report Picklist

[thatgirl100]

Is there any way to add an "All" Option in a report or file picklist? This will be faster, and will prevent my Report Titles from containing a ton of values.

I tried adding a '%' to my file picklist since it's in a text file, so that my prompt opened like this:

Letter:

%
A
B
C

but since in my filter i have "Letter in (? Letter ?)", it's looking for the actual "%", so it returns no results.

Any help would be greatly appreciated!

 

[griffindm]

See faq401-2137

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
Magic with Data
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com

 

[KingCrab]

Easier way is to add a static choice named ALL to your prompt(properties box, click static choices.

Change your filter to be (Letter IN ('?prompt?') OR ?prompt?='ALL')

thats it