Jump to content

Make text appear on bottom of last page


michele
 Share

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

Recommended Posts

Thank you in advance for helping me out.  I need a text (calculation field, text only appears when it's on the last page of the document - size of text varies from 1 line up to 15 lines) to appear on the bottom of the last page of my printed document.

 

I've been testing with the different parts:

 

- footer: seems to be the correct part but the footer part won't slide, even if my field does, so I have this open space in the footer of all the other pages.  I also have a fix text address line in the footer.  I looked for a way to make the footer part slide but even though Filemaker's documentation mentions the sliding of parts I can't figure out how to make the footer part slide.

- Trailing grand summary: would be fine but the field doesn't appear at the bottom of the document

 

Anybody out there with a solution?

Link to comment
Share on other sites

Wrap your calculation in a Case statement:

 

Case(

Get(RecordNumber) = Get(FoundCount); <<yourCalculation>>;

""

)

 

Place the calculation field at the bottom of the Body. Size it for the maximum anticipated height of the enclosed text and set it to slide up, and check the "Also resize enclosing part" box.  Note that the sliding will only show in Preview mode and your printed output.

Link to comment
Share on other sites

Wrap your calculation in a Case statement:

 

Case(

Get(RecordNumber) = Get(FoundCount); <<yourCalculation>>;

""

)

 

Place the calculation field at the bottom of the Body. Size it for the maximum anticipated height of the enclosed text and set it to slide up, and check the "Also resize enclosing part" box.  Note that the sliding will only show in Preview mode and your printed output.

 

Sorry Doughemi but that doesn't work. Thank you for the calculation, I already had a similar calculation so that it only shows on the last page. 

The trouble is that the field slides up, it should show at the bottom of the last page.

 

Anybody a solution?

Link to comment
Share on other sites

There is no good solution for this that I know of. Years ago, Ray Cologon worked out an elaborate method of calculating the number of returns required to push the text towards the bottom of the page, but it may have depended on having a fixed number of records per page - I don't remember that well. How much time/effort are you prepared to spend on this?

 

 

--

P.S. Please update your profile to reflect your version and OS.

Link to comment
Share on other sites

Thank you for your answer comment.  For this solution I'm working on pc (I updated my profile as you requested) and I'm willing to spend time and effort :-)

If this is the only solution I think I can figure a solution myself.  Just wanted to make sure I didn't overlook a feature that existed.

 

Yet, if you have the solution worked out, I'd love to hear about it.

Link to comment
Share on other sites

Yet, if you have the solution worked out, I'd love to hear about it.

 

it's not something I worked out, just an idea: start by checking how many pages you have. Add as many returns to the calculation as possible without increasing the page count. A better way to put it might be: add exactly the number of returns required to increase the page count by 1, then take one return off. I believe the most efficient way to do this is by working with powers of 2.

Link to comment
Share on other sites

This topic is 2600 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
 Share

×
×
  • Create New...

Important Information

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