Symptom
- Export Crystal Report to Excel.
- Customized thousand and decimal characters.
- Field data contains customized separator formatting for number, date, or date time.
- Exported Excel file doesn't contain the customized number, date, or date time separators.
Environment
- Crystal Reports 2008 SP2
- Crystal Reports XI R2 SP5
- Crystal Reports XI R1 SP6
Reproducing the Issue
- Open your report in Crystal Reports.
- Right click on your field in the report designer and select Format Field ...
- Under the Number tab, click the Customize... button.
- Change the Decimal Separator and Thousands Separator to a new/unique value.
- Click OK.
- Preview the report, then export it to Excel format.
- The Excel file will NOT contain the customized separators.
Cause
- The issue has been identified and logged under Problem Report ID ADAPT00232233 and ADAPT01242190.
- This functionality is by design and will not be fixed in a service pack.
Resolution
- Use a formula to convert your data to text if you require special seperators when exporting to Excel.
stringVar thousandSeparator := " ";
stringVar decimalSeparator := ",";
stringVar currencySymbol := "¥";
stringVar myString := ToText({Table.Field}, 2, thousandSeparator, decimalSeparator);
myString := Replace(myString, "$", currencySymbol);
myString;
Keywords
change modify adapt convert thousand Microsoft , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 10.0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2