Dynamic parameter lists and selecting all 1

[senglish]

I am using CR XI
I have a table with authors and have created a parameter to select an author by using a dynamic list and it works fine.

However, I would like to be able to add a * (as you can in a static list) to select all authors.

Is there any way of doing this please?
Stephen

 

[lbass]

I don't think there is a way to do this, but there is no need to, as the user can just select the double arrows (>>) to select all values. You could direct the user in the prompt to do that if they want all values. This assumes you have set up the parameter as a multiple value parameter.

-LB

 

[lbass]

Let me correct my last post. I had tried creating a default list with "all" before, using a command, and hadn't been able to, but it works if you:

1-Do not link the command to the main table or else use a left join FROM the command to the table.
2-You use a "Union", NOT a "Union All", in the command.

Using the Xtreme database, you could "All" to a dynamic List of Values for Shipper including 'all', by going to database->database expert->add command->and entering:

Select Orders.`Ship Via`
From `Orders`Orders
Union
Select 'All'
From `Orders`Orders

I'm not sure why the Union All doesn't work. A union selects distinct values, while a union all should select all values from each side of the union.

Anyway, this assumes that you set up the parameter to allow multiple values, and that you then select the field in the command to populate the list of values.

-LB