SAP Knowledge Base Article - Public

1332634 - Select expert introduces rounding error in Crystal Reports 2008.

Symptom

  • Select expert/formula editor is introduces rounding errors into the selection formula.
  • Example: In the select expert (or formula editor) enter a restriction - {table.fieldname} = 99999 - hit save, run the report and no rows are returned. Return to the select expert and the select expert has changed my restriction to read - {table.fieldname} = 9999.0000000001. This value (99999.0000000001) is then passed to the Database (Oracle) which returns that there are no rows in the database that match that criteria.

Reproducing the Issue

  1. Enter the 'select expert'.
  2. Select 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. Reenter the 'select expert' to see the new value of '99,999.0000000001'.
  • Crystal Reports 2008 Service Pack 1
  • Oracle 10g

Cause

The issue has been identified and tracked under ID ADAPT01184983.

Resolution

Install Service Pack 2 for Crystal Reports 2008.

Keywords

round errors, CR 2008 SP1 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

Product

Crystal Reports 2008 V0