Add "ALL" selection parameter

[capronton]

Does anyone know how to add the "ALL" selection parameter so the user can select "ALL" choices without having to use the double arrows (>>)?

Please see attachment.

Thanks for any assistance.

 

[Charliy]

{?Parameter} = 'ALL'
or {table.field} = {?Parameter}

 

[capronton]

Thanks Charliry

I put this code in the Selection Formula Editor, but the "ALL" is not available for the user to select in the available values list.
Can you explain how I can make that happen?

{day_type_vs.description} = {?ServiceType} and
{incident_log.incident_log_id} Mod 2 = 1 and
{incident_types.incident_name} = {?IncidentName} and
({incident_log.current_route_id} in {?CurrentRoute} or -99 in {?CurrentRoute}) and
{incident_log.incident_date_time} = {?IncidentDate} and
{@TimePeriod} = {?TimePeriod} and
{@earlyLate} = {?cmta_rsaStatus} and
{garage.garage_description} = {?Garage}



Thanks again.

 

[Charliy]

Are you populating the parameter from a field? I don't know how you would add another choice to that list, but there is an easy workaround.

Let's say your drop-down parameter is called {?Pick One}
Add a second parameter called {?I Want It All} that only has options Yes and No (default to No}

Now you select includes:
and ({?I Want It All} = "Yes" or {table.field} = {Pick One})

 

[kray4660]

If you already have a list of values for the parameter, you can add another item. In the past we have used the 'LIKE' operator for the record selection and the Value for the All was the *.

I hope this helps.

 

[capronton]

Kray4660,

I’m trying to add the “ALL” selection to a dynamic prompt/parameter and have not had much success. Can you give me a pretty detailed explanation on how to do this?
Do I have to create a SQL Command that grabs all the values I want for the prompt and join it to another query, that pulls the wildcard (*) value and the word ALL that a user can select.

Or is it a simpler/cleaner way to add "ALL" selection to dynamic prompt?

A clear explanation on this would be greatly appreciated!

 

[kray4660]

I had not used Dynamic List of Values before, so the way I do it does not appear to work here. But if you do a command, you could add a "*" and call it 'All" (select '*' as All, be sure to put the quotes around the asterisk or you will just get all the fields). then I believe it will show up in your list, but then it is doing a cascading prompt. I am sure there are other ways of 'tricking' Crystal Reports with this, but I cannot think of how right now.

Lots of luck.

 

[capronton]

Thanks kray4660.