SAP Knowledge Base Article - Public

2556600 - Display String Formatting applied when exporting a report to MS Excel- Data Only, from Crystal Reports


  • Display String formatting applied when exporting to MS Excel Data-Only.
  • Before applying a product update, the Display String Formatting was not applied when exporting to MS Excel Data-Only.
  • When exporting a report from Crystal Reports to MS Excel- Data Only, or Microsoft Excel Workbook Data-only, it export the Display String Formatting, despite the exporting option to export the formatting is unchecked.


  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
  2. Add at least one field to the report.
  3. Right click on a text field, and select "Format Field"
  4. Under the tab "Common", click on the "X-2" button of the "Display String" option.
  5. Create a formula that change how the string display. For example, truncate the text to only display the first 3 characters.
  6. Export the report to MS Excel Dat-only format.
  7. When opening the exported report in MS Excel, the format used in the Display String is applied, when the expectation is to have the raw data when exporting to MS Excel Data-only format.


  • In previous product update of Crystal Reports, it was not exporting the formatting applied in the "Display String"
  • An enhancement was peformed under SAP Note 2332880, which changed the behavior.
  • The formatting should only have been applied when the export option "export object formatting" is selected, but it is applying despite the option is unchecked. 
  • This issue has been tracked under SAP Note 2555800


  • The issue is resolved in the following product update, and above:
    • Crystal Reports 2013
      • Support Pack 08 - Patch 13
      • Support Pack 09 - Patch 9
      • Support Pack 10 - Patch 3
      • Support Pack 11
    • Crystal Reports 2016
      • Support Pack 03 - Patch 12
      • Support Pack 04 - Patch 6
      • Support Pack 05 - Patch 100
      • Support Pack 06


CR, xls, xport , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed


SAP Crystal Reports 2013 ; SAP Crystal Reports 2016