SAP Knowledge Base Article - Public

1544370 - Select Expert does not return correct data IN Crystal Reports

Symptom

  • When the Select Expert or Formula Editor is used, some data may not be returned IN Crystal Reports.
  • Select expert change the numbers by rounding it off.

Environment

Crystal Reports 2008 Service Pack 1

Reproducing the Issue

1. Open the report in Crystal Reports designer and open the 'select expert'.

2. Pick a number field to filter by.

3. Select 'is equal to' from the filter drop down.

4. Type '99999'(without the quotes).

5. Click OK.

6. Re enter the 'Select Expert' and it shows the new value Of '99,999.0000000001' .

Cause

This issue has been identified and logged under Problem Report ID: ADAPT01184983.

Resolution

This issue has been resolved in Crystal Reports 2008 SP2.

Keywords

select expert, numbers, round off , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

Product

SAP Crystal Reports all versions