Variable height page footer

My report currently has a page number expression at the very bottom of the page footer. On the last page of the report, I'd like to display some report notes immediately above the page number expression (that is, at the bottom-most position of the page). The report notes is a fixed piece of text composed of seven lines.

I achieve this using a textbox in the page footer and controlling its visibility using the CurrentPage and TotalPage i.e. =Iif(Globals!PageNumber = Globals!TotalPages, false, true)

But I find that on the pages other than the last page, the page number expression renders several centimeters up the page (when exporting to PDF).

In other words, the page footer takes up the space of the report notes textbox, even though it renders to hidden.

My report has the ConsumeContainerWhitespace set to true.

Does anyone have a way to resolve this?

more ▼

asked Jan 17, 2013 at 09:53 PM in Default

avatar image

905 60 64 68

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

I would place your text in a textbox in a rectangle on your report body and have that control location and visibility. Placing it at the bottom of the report will ensure it is after all content.

If you ~must~ have it in the footer then I would try using the function of the footer content to control the value shown in a single text box.

something like
=Iif(Globals!PageNumber = Globals!TotalPages,
"All your text here in a single string" & vbCRLF & Globals!PageNumber & " of " & Globals!TotalPages,
Globals!PageNumber & " of " & Globals!TotalPages)

more ▼

answered Jan 18, 2013 at 11:12 AM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 17, 2013 at 09:53 PM

Seen: 1743 times

Last Updated: Jan 18, 2013 at 11:12 AM

Copyright 2018 Redgate Software. Privacy Policy