SAP Knowledge Base Article - Public

1912507 - No records returned when a list of values is entered into a parameter field

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:

Untitled.png

  • 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