SAP Knowledge Base Article - Public

2112335 - Multiple extra records generated when exporting a report to CSV fromat from Crystal Reports

Symptom

  • Duplicate records.
  • More rows of data exported to CSV, than what is seen on the report.
  • Suppressed details section appears in the generated CSV file by Crystal Reports.
  • When exporting a report to CSV format from Crystal Reports, it generates multiple duplicate records.

Environment

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

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
  2. Insert a group.
  3. Insert database fields in the Group Footer or Header section.
  4. Suppress the Details section.
  5. Export the report to CSV format.
        
    Notice the is more rows of data in the CSV file, than what is seen on the report.

Cause

  • By default, when exporting to CSV format, it exports the data as seen in the Details section, therefore this is why the number of rows of data is differenty because only the Group Footer or Header section is displayed on the report.
       
  • On the report, if we were to display the Details section, it will display the same number of rows of data in the report than in the CSV file generated.

Resolution

  • To only export to CSV format the data located in the Group Header or Group Header section, follow the steps below:
    1. Open the report in Crystal Reports.
    2. Under the menu "File", select "Export - Export Report"
    3. Select Seperated Values (CSV)
    4. Select "Do not Export" option under "Report and Page Section" on the Separated Values Export Options window.
    5. Also, Select "Export" option and check the "Isolated Group section box" under "Group section"
    6. Click on OK.

Keywords

crystal reports, csv, export csv, export, multiple records, cr, cr2011, cr2013, cr2008 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016