Symptom
- Values entered individually into a multi-select parameter show up correctly.
- Values entered as ['75001','75002'] do not return any data.
Environment
SAP Crystal Reports 2011
Reproducing the Issue
- Enter a list of parameters into a multi-select parameter parameter:
- Using the same approach in a Crystal Reports formula works as expected:
{Job.Job} IN {?List of Jobs}
AND
{Job.Status} IN ['Active, 'Complete', 'Hold']
AND
{Job Operation.Status} IN ['O', 'S']
Cause
- Crystal Reports expects an array with multi-select parameters.
- Square brackets in a Crystal Reports formula indicate that an array is being used.
- When brackets are entered into the parameter entry screen they are not converted into an array.
Resolution
- Enter all parameter values individually
Keywords
CR param LOV null empty blank , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
SAP Crystal Reports 2011