cancel
Showing results for 
Search instead for 
Did you mean: 

Large whitespace in exported Excel (Crystal Reports for Enterprise)

Former Member
0 Kudos

Hi there,

I am creating a report that will be exported in both PDF and Excel.  I would like to have page footers displayed on each page for the PDF (at the bottom), and have the page footer appear once at the bottom of the Excel file (after the last record).

In the Excel export options, I have the page headers and page footers set to Once per report.  The PDF export is perfect (page headers and footers appear on every page, as expected), but the Excel file contains a large row of empty cells below the final record, and above the footer.  Is there a way to suppress this in CR for Enterprise without using the Clamp page footer on the last page?  If I do clamp the last page, it solves my problem for the Excel, but it shrinks the height of the last page in the PDF, and when printed, appears in the centre of the page.

An alternative I tried was to display the page footer on every page other than the last page, and have the report footer (contains copy of page footer contents) display only on the last page.  I set the report footer to 'Print at the bottom of page,' but this gives me the same results as before, with the large whitespace.  If I do not set the report footer to print at the bottom, then the Excel is correct, but in the pdf, the final page will have it's footer not at the bottom.

Any help or ideas would be appreciated.

Cheers,

JP

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi JP,

That white space you see above the Page Footer in the Excel is the space that shows up in the report.

Excel only needs reasons to add blank rows, merge cells etc and there is some good reason to do that on the last page.

In my opinion, you cannot really design a report that can do justice to all exporting formats, this case PDF and Excel. You either have to create two versions of the report - one that is designed specifically to export to Excel and the other for PDF.

-Abhilash

abhilash_kumar
Active Contributor
0 Kudos

Or you can perhaps you can add a parameter to the report that prompts the user to choose whether they would like the report to be exported to PDF or Excel.

If they choose Excel, you can keep the formatting as it is. If they Choose Excel, you can use a conditional suppression formula on the last page of the report for the Report Footer and the Page Footer.

-Abhilash