1334606 - Export Crystal Report to Excel ignores custom number, date, time separators

SAP Knowledge Base Article - Public

1334606 - Export Crystal Report to Excel ignores custom number, date, time separators

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

  1. Open your report in Crystal Reports.
  2. Right click on your field in the report designer and select Format Field ...
  3. Under the Number tab, click the Customize... button.
  4. Change the Decimal Separator and Thousands Separator to a new/unique value.
  5. Click OK.
  6. Preview the report, then export it to Excel format.
  7. The Excel file will NOT contain the customized separators.

customstyle.png

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

  1. 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 BusinessViews 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