7 Replies Latest reply: Oct 2, 2013 9:42 AM by Eddie Lotter RSS

    Page Footer whitespace

    hamor185 Community Member
    hamor185 Sep 26, 2013 1:50 AM

      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.

      • 884 Views
      • Tags:
        • 1. Re: Page Footer whitespace
          Eddie Lotter Community Member
          Eddie Lotter Sep 26, 2013 8:27 AM (in response to hamor185)

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

          • 2. Re: Page Footer whitespace
            hamor185 Community Member
            hamor185 Sep 26, 2013 10:54 PM (in response to Eddie Lotter)

            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. :-)

            • 3. Re: Page Footer whitespace
              Eddie Lotter Community Member
              Eddie Lotter Sep 30, 2013 8:41 AM (in response to hamor185)

              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.

              • 4. Re: Page Footer whitespace
                hamor185 Community Member
                hamor185 Sep 30, 2013 7:19 PM (in response to Eddie Lotter)

                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.

                • 5. Re: Page Footer whitespace
                  Eddie Lotter Community Member
                  Eddie Lotter Oct 1, 2013 8:24 AM (in response to hamor185)

                  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?

                  • 6. Re: Page Footer whitespace
                    hamor185 Community Member
                    hamor185 Oct 1, 2013 8:50 PM (in response to Eddie Lotter)

                    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! :-)

                    • 7. Re: Page Footer whitespace
                      Eddie Lotter Community Member
                      Eddie Lotter Oct 2, 2013 9:42 AM (in response to hamor185)

                      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.