Show footer on last page only

Question

I want to add footer on my report, but only on the last page. I followed this tutorial which was successful, but it leaves space for the footer on all pages.

How can I get rid off that space for the footer on all pages except the last one?

Gil Peretz · Accepted Answer · 2013-02-13T08:31:21.897

4

I can only think of the following solution for your problem:

First - don't use the build in Footer. Instead, use a sub-report that will contain your footer details.

Now, you need to define the sub-report as thin as possible in the main report (while in the actual sub-report - arrange your data as you want).

Then just implement the same concept as described in the link that you provided - means that you need to define an expression in the sub-report visibility filed.

attaching a demonstration that explaining the 'using sub-report' idea:

enter image description here

EDIT I did some research - If you follows the instructions provided by the link in your question but Strech the rectangle to cover all the footer area, then your are good - the footer will not be displayed until the last page:

This how I arranged the Rectangle over the footer:

Middle Page (you can see that the footer's rectangle is hidden:

enter image description here

Last Page (footer is visible):

enter image description here

edited Feb 13 '13 at 08:31

answered Feb 13 '13 at 07:45

Gil Peretz

2,399
6
28
44

Yes but globals only can be used in page header and footer. I mean to say globals.pagenumber – k-s Feb 13 '13 at 07:56
You right, sorry didn't thought about it . I edited my answer - see now – Gil Peretz Feb 13 '13 at 08:31
But the red part is the footer of the main report ? If yes, then where is the subreport ? Thankx – Adrian T Jun 09 '23 at 16:05

Show footer on last page only

1 Answers1

Linked