Jump to content

A way to force another page?


whardy

This topic is 1031 days old. Please don't post here. Open a new topic instead.

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 comment
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 comment
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 comment
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 comment
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 comment
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 comment
Share on other sites

This topic is 1031 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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