SAP Knowledge Base Article - Public

1507107 - Headers repeating for each row when exporting to CSV format from Crystal Reports for Enterprise

Symptom

  • Headers repeats on each line.
  • Page Headers are repeated for each row when the report is exported to the CSV format.
  • When exporting a report to Comma Separated Values format (CSV) from Crystal Reports for Enterprise, the text headings are repeated on every row of record.

Environment

  • SAP Crystal Reports for Enterprise 4.0
  • SAP Crystal Reports for Enterprise 4.1
  • SAP Crystal Reports for Enterprise 4.2

Reproducing the Issue

  1. In Crystal Reports or Crystal Reports for Enterprise, create a report off any data source, and add a couple of database fields to the details section.
     
    KB01.png

  2. Export the report to Comma Separated Values format (CSV)
         
  3. When opening the exported report in a text application like "Notepad", notice the page headers are repeating for each row of data.
     
    KB02.png

Cause

  • By default, when exporting a report to Comma Separated Values (CSV) format, it will repeats the text located in the header section for each row. It is normal behavior.

Resolution

  • To only export the header information once, check the CSV exporting option to "Isolate Report/Page Sections".
      
    1. Export the report to Comma Separated Values (CSV) format.
          
    2. In the "Export Options" window, check the option "Isolate Report/Page Sections"
        
      KB03.png
       
    3. The report will now only export the headers once in the CSV document.
        
      KB04.png
        
        
         
  • Note: This option is available from Crystal Reports XI R2 and above.

Keywords

CSV,Page Headers,Crystal Reports Export. CR, CRE, CR for Enterprise, CR4E , 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