How can I allow the user to "select all" from a .lov 1

[Hutch56]

I don't want the user to have to Control + Shift to select all the values from an @prompt. How can I place a variable within the list of values that states "Select all"?

 

[brian512]

Hi, I was showed this tip in training, though I haven't actually used it yet:

Doing it from Designer:

Create your object, using the @Prompt function, plus add a condition to check for All values:
{Table.column or Class\Object name} = @Prompt('Enter Division Code or All','A',,multi,free)) OR ('All' = @Variable('Enter Division Code or All'))

Doing it from the Query Paney (the end user side):

In Designer, create a generic object called, "All" for example and make its SELECT statement equal to 'ALL' (including the single quotes). Save the object without parsing.
Then in BusinessObjects, create your condition as usual, with your desired prompt. For example:
Division Code Equal to Prompt ('Enter Division Code or All')

Then, create one more condition, this time on the object 'All'. Use the option "See list of prompts" to select the same prompt again for this second condition. MAke sure you set the OR operator between conditions, so you end up with the following:

Division Code Equal to Prompt ('Enter Division Code or All')
OR
All Equal to Prompt ('Enter Division Code or All')

If the user enters a Division code, teh first condition will be true, teh second false, and the user will only retreive data for the requested value. If the user enters the word All, the first condition will be false, but the second condition will be true, and it will get data for all values.

Hope this helps!
Brian