Jump to content

A way to force another page?

Recommended Posts

If a report only has one page, I still need it to print a second page in order to print the footer. What is the most efficient way to force another page, even if it is blank?

Link to post
Share on other sites

Some more details would be useful - e.g. is this a list report? What parts does it have? Why is it necessary "to print a second page in order to print the footer"? Do you have a title footer on the first page? And are you actually printing or saving to PDF?


Link to post
Share on other sites

List Report: Yes

Title Footer: Yes

Printing: User can choose whether to Print or save to PDF after viewing

Why: A task for printing an announcement sheet for a non-profit was taken from a graphic designer using inDesign and given to someone who does not need to learn inDesign nor FileMaker. It is basically a list, so I think FileMaker should be able to handle it, although taxing it (and me!) because of a couple "graphical" requirements FileMaker doesn't do naturally. 

Header: Graphic, text, date, etc.

SubSummary: Type of announcement

Body: Announcement

Trailing Grand Summary: Horizontal lines for the user to write on that fills the space after the announcements until the footer

Footer: Financial graphic, text (THIS IS REQUIRED at the bottom of the 2nd page after the horizontal lines for user notes)

Title Footer: "Continued on back" if more than one page.

Problem: There are too many announcements for some note lines and financial graphic to fit on the first page, but not enough to insure there is a second page.

I'm not sure if that made it easier or worse...

(I'm considering adding one hidden announcement that can contain a variable number of returns to force a page break. I just have to figure out how to make that look smooth and not stupid. )

Link to post
Share on other sites

I have seen a similar requirement a few times before, but not with a footer. Usually the requirement is to print some information at the bottom of the last page - which is not necessarily the 2nd page. It seems you're confident there will never be a 3rd page.

Anyway, I don't know of an easy solution to either. The best I have seen is similar to your idea: place a shrinking global field in the Trailing Grand Summary part and add carriage returns until the page count increases to 2. This can be made more efficient by starting at some maximum and moving down by powers of two.



Edited by comment
Link to post
Share on other sites

I thought that might be the answer. I know the get(PageCount) is new, but where will it be valid? I've tried to get it show up in Data View during a Preview, but the value returns blank, even though there are two pages. When does get(PageCount) actually show data? 

Link to post
Share on other sites
6 minutes ago, whardy said:

When does get(PageCount) actually show data? 

I don't know. I am still on v.18. I have seen some bug reports regarding this function and its associated symbol. Meanwhile you can use the old method of entering Preview mode, going to the last page and getting the page number.


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Similar Content

    • By Bobby Bradley
      I have a layout for printing on a letterhead and have inserted an image file as the Background Image to serve as the letterhead.  Printing and Save to PDF work as expected, but for the life of me I cannot get the background image to display correctly in Preview mode.
      Not displaying correctly in Preview mode is not terrible except, when the client does a print preview and it doesn't line up, there will be questions...even though it print correctly.
      Basically, it looks like the background image has a pre-determined padding applied to it at the top, but all parts and objects are set to padding 0.
      Has anyone else experienced this?
      Preview mode - letterhead has padding

      Printed PDF - the letterhead is up where it should be:

    • By datalink
      We are developing a contract layout for a client.  There is a modestly long header (260 its.), short body (26pts), but a very long footer that is one large text box detailing terms and conditions.  Its boiler plate but they need it there.  Since it is one large block it won't print on the first page.  Instead in preview mode the bottom half of the page, below the body, is blank and the boiler plate starts on a second page. 
      Is there a way to have this last large text block start on the first page and spill over onto a second page?
      How can I get this to format correctly as one cohesive document?
    • By Geeksharka
      Anyone else having this problem?
      When I format the fill and/or borders on fields, they:
      Only show up in browse mode for the active record (none of the others) Formatting disappears completely on Preview Mode I have Alternate Row and Active Row states set to off.
      I'm hoping it's something simple that I just can't seem to find. I've uploaded the Browse, Layout, and Preview mode screenshots of a layout where this is a problem,

    • By Orchid28
      I need to figure out how I can add a header, a footer, a page #, and current date onto the Table View?
    • By Shields
      I have a report that is causing printing problems.

      The way this report works is that it gathers data from all over the system, and then creates individual report records ("BodyText," "BodyTextIndent," etc). Those records allow me to customize page breaks and easily set margins, etc.

      However, the problem I am running into is that when we view the report in Preview Mode, it looks fine (sometimes it happens naturally, other times we have to use my system of Sub-summary page breaks - but that is not the issue here). Sometimes when we print out the report, the page break that is printed is not the page break that is displayed in Preview Mode.

      It seems as though the printing process shrinks the margins of the layout by maybe 1/4 inch, at most. But that is enough to send the record on the bottom of the page to the top of the next page.

      It's not a driver or printer issue, as this has happened on multiple printers from multiple machines, and it also happens when saving to a PDF.

      If anyone has seen this issue before, I would appreciate any input you might have.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.