1621206 - How to remove blank row above Page Footer when exporting Crystal Reports report to Excel

SAP Knowledge Base Article - Public

1621206 - How to remove blank row above Page Footer when exporting Crystal Reports report to Excel

Symptom

  • There is space above Page Footer in Crystal Reports (CR) report if there is not enough data on each page
  • By default there is a blank row above Page Footer rows after Exporting to Excel file
  • The height of blank row in Excel file depends on height of space in CR report

Environment

  • Crystal Reports 2008 
  • SAP Crystal Reports 2011

Reproducing the Issue

  1. Create a CR report based on eFashion Universe.
  2. Drag [Year], [Quarter], [State] and [Sales revenue] object to Result Objects pane.
  3. Click Insert > Group, Insert Group dialogue is displayed.
  4. In Common tab, group Year object in ascending order.
  5. In Options tab, check New Page After 1 Visible Groups.
  6. Go to Design Mode.
  7. Hide Group Footer #1.
  8. Insert Text Object into Page Footer and input “This is Page Footer” on Design mode.
  9. Go to Preview Mode.
    =>Note that there is space above Page Footer.
  10. Export report to Excel file by clicking Export > Export Report > Microsoft Excel (97-2003).
  11. In the Excel Format Options dialog, under Export page headers and page footers field, select On each page.
  12. Open the exported excel file.
    =>Note that there is a blank row above Page Footer. And the height of blank row in Excel file depends on height of space in CR report.

Cause

By default there is a blank row above Page Footer rows after Exporting to Excel file, this is by design.

Resolution

  1. Open the CR report.
  2. Go to Report > Section Expert > Page Footer and check Clamp Page Footer.
  3. Go to Preview mode.
    =>Confirm that there is no space above Page Footer in CR report.
  4. Export report to Excel file.
  5. Open the exported excel file.
    =>Confirm that there is no blank row above Page Footer.

Keywords

Section Expert, Clamp Page Footer , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011, feature pack 03