Allow User to select "ALL" in the parameter

[capronton]

How can I give user the option to select ' ALL' in the parameter prompt? Instead of selecting multiple routes, I want the user to be able to select "ALL" routes.
Thanks for any suggestions.

 

[AndyMc]

The way I do it -

In your selection statement - if your parameter is called {?Route}:

(
if {?Route} = "ALL" then
true
else
{yourRouteField} = {?Route}
)

 

[pmax9999]

Rather than using an If-Then-Else statement in the Record Selection formula, I prefer to take the following approach which I have found is more likely to get passed into the SQL Select statement (depending on data source) and therefore improve efficiency):

(
	{?Route} = "ALL" or
	(
		{?Route} <> "ALL" and
		{yourRouteField} = {?Route}
	)
 )

Hope this helps.

Cheers
Pete

 

[capronton]

User still cannot see the keyword " ALL" in the dynamic prompt list menu option. Do I have to create a SQL Command query that grabs all values and the keyword " ALL"?

Or is there another way to get the keyword " ALL" to display in the dynamic prompt list menu option?

 

[pmax9999]

Yes, if using a Dynamic Parameter you will need to use a SQL Command so you can add the "All" option to the available alternatives.

Cheers
Pete