SAP Knowledge Base Article - Public

1631236 - Xcelsius chart not showing when exporting a report to MS Excel format from Crystal Reports

Symptom

  • Chart missing.
  • When exporting a report to MS Excel, the graph are not displayed.
  • Chart does not show when a report with an embedded Xcelsius chart (SWF) is exported to MS Excel from Crystal Reports.
        
  • Important Note
    Adobe ended Flash support on 2020/12/31. The information in this SAP Knowledge Base Article was valid prior to Flash support ending. The recommendation is to remove Flash objects from the report. 

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. In Crystal Reports designer, open or create a report.
  2. Under the menu "Insert", select "Flash", and select an Xcelsius Chart (SWF)
  3. Export the report to MS Excel format,
        
    When opening the exported document, notice the place where the chart is on the report, is blank on the MS Excel spreadsheet.

Cause

  • Flash is not a supported functionality when exporting to MS Excel. This is why there is no chart in the MS Excel spreadsheet.

Resolution

  • The only exporting format that support exporting flash is PDF format.

Keywords

SWF, Flash, Crystal Reports, Export to Excel, Blank Chart , 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