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

• 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

• Crystal Reports 2008 
• SAP Crystal Reports 2011

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.

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

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.

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

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