SAP Knowledge Base Article - Public

1459669 - Wrong data appears in a exported file when a Crystal Report is exported to any format

Symptom

Wrong data appears in a exported file when a Crystal Report is exported any format

Environment

Crystal Reports 2008 V1

Reproducing the Issue

  1. Create a crystal report having sub reports in it
  2. Create a formula in main report which contains a share variable getting data from sub report
  3. Preview the report. Value appears correctly
  4. Export the same report to XML or Excel format. The value returned by the formula changes in exported file

Note: The issue was observed with specific reports and not reproducible with inhouse data.

Cause

Sub-report is corrupted however the reason behind corruption can not be identified.

Resolution

  1. Open the report in Crystal Reports designer.
  2. Right click the sub-report and click 'Save Subreport As' and save it separately.
  3. Now remove the sub-report from the main report.
  4. Insert it again at the required location in main report.
  5. Create the required links between main report and sub-report.

Keywords

KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1