Crystal Reports uses a parameter to limit a report by record. Follow the steps below to limit a report to one record or all records:
    • Click the Set Default Values button to define the allowed values. Include 'ALL' as an option.
    • Select Report, Select Expert
    • Select Show Formula, Formula Editor
    • Add:

      (if {?ParameterField} = "ALL" then {PARAMETERDEFAULTVALUEFIELD.EN_US}
      like "*" else {PARAMETERDEFAULTVALUEFIELD.EN_US} = {?ParameterField})
    • Save and Close the formula
    • Click OK to close the Select Expert