SAP Knowledge Base Article - Public

1657626 - Number data type field with 16+ digits in Crystal Reports cannot be fully displayed

Symptom

  • Number data type field with 16 or 17 digits in Crystal Reports (CR) will be rounded
  • Number data type field with 18+ digits in CR will be displayed in scientific notation format

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2013

Reproducing the Issue

  1. Create a new CR report or open an existed CR report.
  2. Add a new Formula Field with 16 digits named NumberWith16DigitsUnder5 and set its value as “1111111111111114”.
  3. Drag NumberWith16DigitsUnder5 into report.
    => It will be rounded down at last digit.
  4. Add a new Formula Field with 16 digits named NumberWith16DigitsOver5 and set its value as “1111111111111115”.
  5. Drag NumberWith16DigitsOver5 into report.
    => It will be rounded up at last digit.
  6. Add a new Formula Field with 18 digits named NumberWith18DigitsUnder5 and set its value as “111111111111111114”.
  7. Drag NumberWith18DigitsUnder5 into report.
    => It will be displayed as scientific notation format.
  8. Add a new Formula Field with 18 digits named NumberWith18DigitsOver5 and set its value as “111111111111111115”.
  9. Drag NumberWith18DigitsOver5 into report.
    => It will also be displayed as scientific notation format.
     

Cause

This issue is by design.

See Also

1210689 - Reporting off an Oracle database that has a Number Data Type field with 16+ Char

Keywords

CR, Number, Number field, 16+, 18+, over 16, over 18 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2013

Attachments

Number data type field with 16+ digits in Crystal Reports (CR) cannot be fully displayed.docx