Setting up a report to give all values or choose from the parameters

[Hacim]

Using CR 8.5 w/SQL
Is there a way to design a report that would allow somone to choose a specific value in a parameter prompt or allow Crystal select all the values in a field.
Example: If someone using a viewer wanted to see a report on all of {wo.location}s or they wanted to choose a specific location, how would you set up a parameter to allow that kind of flexiblity. In other so they didn't have to choose every location during the parameter prompt.
TIA

 

[IdoMillet]

Allow them to enter "ALL" in the parameter and in your record selection formula use something like:

({?Parm} = "ALL&quot OR ({wo.location} = {?Parm})

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Hacim]

Thanks, that works great.
Does creating the 'ALL' selection in the parameter work because Crystal does not recognize that selection, therefore chooses all the values for that field?
Thanks again

 

[IdoMillet]

It works because of the logic in the record selection formula. If the value is "ALL" the formula would always evaluate to TRUE.

Cheers,
- Ido


CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com