1 Reply Latest reply on Sep 19, 2013 9:10 AM by philmodjunk

    Trailing Grand Summary pushed to extra page



      Trailing Grand Summary pushed to extra page



           I'm using FileMaker to populate a form and for some reason my trailing grand summary is being pushed to an entirely new page.  The title header contains the static information that must be on the form for signatures, the body is list of fields, and the grand summary contains the "HR Only" section that only needs to at the end of the document (not on every page).  Depending on the information selected, the documents range from 2 pages to 27 pages and if I move the HR Only section to the footer it forces the department to sign every single page when they only really need to sign the last page.   When I adjust the trailing summary to follow immediately after the body, it moves the section to the middle of the page- it must stay on the bottom.  I deleted it and reinserted it and still get the same problem.  How can I adjust this so I don't have a blank page at the end with the summary?  Thanks!

        • 1. Re: Trailing Grand Summary pushed to extra page

               Trailing Grand Summaries are designed to "close up" the blank space and appear after the last record in the Body. That may not be what you want, bit it is what it was designed to do.

               You could make this info appear at the bottom of the title page by putting it in a title footer.

               You could put it in the footer using a calculation field or fields that are empty if Get ( RecordNumber ) does not equal  Get ( FoundSet ) . The two values are the same only for the last record. But since fields in the footer can't be set to "slide up and resize", the space allocated for this info would be present on every page even if there is nothing showing so I have my doubts that would work for you.

               The final thought that comes to mind is that you might be able to add in some special blank records after the last real record to "pad" the page such that your trailing summary shows at the bottom of your page. You might be able to use a script to add and remove such records if the space taken up by each record in the body is the same fairly easily. It's still possible with sliding fields, but the process get's really complicated and takes a special script that previews your report repeatedly until it get's the right stuff in place for your report.