'ALL' Prompt in Cognos

Hi all,
Could you please help me with this issue?
I need to create a picklist prompt that has default value 'All' and lists all the values in the database for that field,so the user can either select one value or selcet 'ALL'.How do I create the prompt with 'ALL' values?
Thanks in advance for your help

one work around is create two prompts, one prompt will display all possible
DB values and other prompt will be file picklist with All or Null option.
then in filter put condition
((Prompt1= All) or (Prompt1 <> All and Prompt 2 = DB value),
if user selects All then report will take condition1 and wont filter by DB
values and select All values.
if user doesn't select All and keep prompt 1 as null then condition 2 will
pick DB value
Regards
Inder

Hello, you can add the 'ALL' option by adding a HTML item to your page and then inserting a .js reference to set the prompt control's item #1 to be the text 'ALL'.
<script>
document.formWarpRequest._oLstMyList[0].text = '--ALL--';
</script>

From impromptu version i don't know the answer but from Cognos
8 point of view if we talk about Text box Prompt
in filter condition were it end there only add this statement *or 'All' in
?parameter1?* that's it.

I am using the "allow the user to select all values" in the prompt manager (impromptu 7.4) and was very excited to learn this was a feature of the product, but when I post this report to the Impromptu Web Reports and select the <All> option, my report comes up empty. The event viewer only shows an error that is "Unknown Internal Error".
Any suggestions? I checked the Cognos Support Site, but no posts. Wondering if maybe it's a sql error. Using MSSQL 2005
Thanks in advance for any help.
sj

If this is Cognos 8, Reportnet then you don't need an 'ALL' value, you make your prompt [table name].[column name] in ?Paramater?, you make ?Parameter? let ?Parameter? 'Allow Multi Select', then when your users run the report, if they want a value they select one from the drop down list which is then used, if they select nothing then this is works the same as selecting 'ALL', you just need to train your users to select a value, or select nothing (to get all). I think you also need to make the prompt optional!

we have to give 'All' in static choices and this should be
associated with filter of that corresponding prompt.
For eg:
Below is Ur filter for product,
[Table name].[column name] in ?Parameter name?
Then u have to associate like this,
[Table name].[column name] in ?Parameter name? Or ? Parameter name? = 'All'
I think this will be useful for u ....
Thanks,
Pavithra.

When you use 'IN' as part of the filter, the user can select all values by clicking 'Shift' plus first value and last value in list. This will select All values.
Example: Country in (?Country?)
Your prompt must use catalog pick list to display all possible vaules in the database.
Another option is to use a file with all the values from the database plus "All Values" and have the prompt use a file picklist.