Page Footer whitespace

[Guest]

I have an invoice report that had N number of line items with N number of lines of description per line item. The invoice displays all of the line items, and then at the bottom of the last page, it provides a signature block for the customer to sign. Here is my problem: If I put the signature block in the page footer, it's displayed at the bottom - which I want - but repeated on every page. If I put the signature block in the report footer, it's displayed on the last page - which I want - but immediately following the last line item. I need it at the bottom of the last page only. The closest I have gotten is to try and predict the number of page that I will have and then hide the page footer until (what I think will be) the last page. However, this still have the page footer whitespace to show up which isn't right.

[EddieLotter]

Are you using the "Print When Condition" of the Page Footer itself, or of a field in the Page Footer?

[Guest]

The whitespace is the height of the page footer showing on the pages even the whole band is hidden based on a varivable (Print When Condition).

I saw the same reported article on this. The guy eventually changed to another reporting tool. I still have high hopes into figuring a solution on this. Hope I could find some help here. 🙂

[EddieLotter]

I can confirm that even if the page footer is set to print only when a condition is true, all pages reserve the size of the footer.

What you can do is put your signature block fields in the "Watermark" band and set them to only print on the last page. Since the watermark can print anywhere on the page you can put the fields in the exact positions you want them to appear on the page.

If the signature block has a lot of fields, you can conveniently put them in a subreport and put the subreport in the Watermark band. That way you only need to set the print condition on the subreport rather than all the fields.

[Guest]

I have tried that solution but the problem was, it (watermark content) will overlap with the last record of the report. Since watermark position is fixed.The signature section's height is almost 1/3 of the total page size. Where dimension of my document is: Letter 8.5 in x 11.0 in.

[EddieLotter]

That does make it difficult, however, if your line items are a fixed height then you can calculate whether the last page will have the overlap problem. You can have two subreports, one with a page break and one without. You can show the relevant one depending on the overlap calculation.

Purely for intellectual curiosity, why does the signature block have to be bottom aligned?

[Guest]

It is based on the client's requirement that the signature block should be shown at the bottom of the last page. Actually, the report was originally in Crystal Reports. Because of some upgrades, it was then migrated to CF Reports.In Crystal Reports, there's an option to display the report footer at the bottom of the page which CF Reports doesn't have.

Anyways, I have reduced the height of the signature block into half at make the other half appear only at the last page by palcing it in another group and let it float.

Thank you for giving time to answer my posted problem. I really appreciate it! 🙂

[EddieLotter]

hamor185 wrote:

Thank you for giving time to answer my posted problem. I really appreciate it! 🙂

You're very welcome.

I'm glad you managed to find a solution that works for you.