Symptom
- Missing decimal values.
- Number rounded to 2 decimals.
- Percentage value formatted to display more than 2 decimals, are only showing 2 decimals in MS Excel.
- Only 2 decimals are displayed for percentage, when opening in MS Excel a report exported to CSV format from Crystal Reports.
- Numbers that are not displaying percentages displays more than 2 decimals when exported to CSV format from Crystal Reports.
Environment
- SAP Crystal Reports 2008
- SAP Crystal Reports 2011
- SAP Crystal Reports 2013
- SAP Crystal Reports 2016
Reproducing the Issue
- In Crystal Reports, create a report off any data source.
- Insert a percentage summary.
- Format the percentage value to display more than 2 decimals, like: 85.1234%
- Export the report to CSV format.
- When opening the exported report in MS Excel, it truncate the value to 2 decimals like: 85.12%
Cause
- This situation only occurs for percentage values.
- Crystal Reports exports the whole percentage value with all it's decimals to CSV format as expected, but when the CSV file generated is open, it is MS Excel that automatically format the percentage values to display 2 decimals.
Resolution
- To view the percentage value with more than 2 decimals, perform one of the following:
- Open the CSV file in a text application, like Notepad, to see the percentage values with all the decimals, or
- If you want to view the exported report in MS Excel, then export to "MS Excel (97-2003) - Data Only" format, instead of CSV format.
Keywords
CR, xport , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016