SAP Knowledge Base Article - Public

2800069 - Page Header prints before the Report Header when exporting a report to MS Word Editable from Crystal Reports

Symptom

  • Column Headers displayed before the cover page in MS Word.
  • In Crystal Reports, the Report Header display before the Page Header, as expected.
  • In MS Word, when opening a report exported from Crystal Reports to MS Word Editable, it shows the Page Header text before the Report Header text.
        
         
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
              
  • 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, create a report off any data source.
  2. Insert at least one database fields in the Details section.
  3. Insert Column Header(s) in the Page Header section.
  4. Insert text in the Report Header section.
  5. When refreshing the report, notice the text inserted in the Report Header section show before the Column Headers located in the Page Header section.
  6. Export the report to Microsoft Word (97-2003) Editable format.
  7. When opening the document generated in MS Word, it shows the Page Header text, before the text that was inserted in the Report Header section of the report. 
      
    Export to MS Word - Editable.jpg

Cause

  • Limitation of the Microsoft Word (97-2003) Editable format exporting driver.  
         
  • The Microsoft Word (97-2003) - Editable exporting driver does not have the functionality to export the Report Header section to a Cover Page section of a MS Word document, therefore it export the text to the body section of a MS Word document, and this is why the text in the Page Header, like Column Headers, displays before the text you see in the Report Header section when exporting a report from Crystal Reports to MS Word Editable format.

Resolution

  • Export the report to a different format that supports exporting the Report Header before the Page Header:
    • MS Word
    • Rich Text Format (RTF)
    • PDF
                
          
  • For a list of supported functionalities by exporting format, see the SAP Knowledge Base Article 1946358

Keywords

CR, xport , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016