Symptom
- Negative number, displays as positive number.
- Number Sign is reversed, after exporting a report from Crystal Report to MS Excel format.
- In Crystal Reports, when a number field in a report is formatted with the option 'Reverse Sign for Display', and the report is exported to MS Excel, the negative numbers in the database are changed to positive number in Crystal Reports, but then display as negative in the Excel spreadsheet.
Read more...
Environment
- Crystal Reports 9
- Crystal Reports 10
- Crystal Reports XI
Product
Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 10.0 ; SAP Crystal Reports 2001 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports 9.0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2
Keywords
CR CE WHF 338484 EXPORT MS EXCEL REVERSED REVERSE NEGATIVE POSITIVE DATA BASE Crystal Reports Export to Excel Reversed positive values , c2017328 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.