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
- Create a new CR report or open an existed CR report.
- Add a new Formula Field with 16 digits named NumberWith16DigitsUnder5 and set its value as “1111111111111114”.
- Drag NumberWith16DigitsUnder5 into report.
=> It will be rounded down at last digit. - Add a new Formula Field with 16 digits named NumberWith16DigitsOver5 and set its value as “1111111111111115”.
- Drag NumberWith16DigitsOver5 into report.
=> It will be rounded up at last digit. - Add a new Formula Field with 18 digits named NumberWith18DigitsUnder5 and set its value as “111111111111111114”.
- Drag NumberWith18DigitsUnder5 into report.
=> It will be displayed as scientific notation format. - Add a new Formula Field with 18 digits named NumberWith18DigitsOver5 and set its value as “111111111111111115”.
- 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 Business View 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 |