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

• 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

• Crystal Reports 2008
• SAP Crystal Reports 2013

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.
    

This issue is by design.

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

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