SAP Knowledge Base Article - Public

1552419 - Crystal reports do not show correct data when record selection formula is applied.

Symptom

Crystal reports do not show correct data when record selection formula is applied.

Environment

Crystal Reports 2008V1

Reproducing the Issue

  1. Create a report and add a record selection formula as follows:
    {table.field1} startswith "ABC" or {table.field1} startswith "XYZ"
  2. Save the formula and refresh the report. Expected data is not shown.

Cause

Even though the formula is syntactically or logically correct it is not understood by the Select Expert.
Only thing it understands from above formula is that record selection is based on the field {table.field1}. Select Expert creates a different formula to achieve the same result.

Resolution

  1. Edit the report in Crystal Reports designer.
  2. Click Report>>Selection Formulas>> Record. Formula Editor opens.
  3. Modify the record selection formula as follows
    {table.field1} startswith ["ABC","XYZ"]
  4. Save and Close the formula editor.
  5. Refresh the report.

Keywords

KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1