Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Printing parent record when portal has scroll bar and not all child records show in one page


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

Recommended Posts

Posted

Anyone know how to go about printing a record (from form view) when the record contains a portal with a scroll bar and there are more child records than can be seen without scrolling?

My portal shows 10 lines. Say there are 15 child records in the portal. How can I print the form view of the parent record showing the first 10 child records, then have a 2nd page print the same info from the same parent record in form view but have it automatically scroll to show the next 5 child records? I want it to be set up to require as little interaction from the user as possible. So a button on the layout linked to a script would be ideal, unless there's some built in feature that does this already that I'm not aware of.

Posted

Usually you would print from the child records view. From here you can show to the Parent data, and you can set an option on the Body part to make a page break at every 10 occurences.

But if you cant fit your layout into this structure, with the child records full width in the middle of the page, you are out of luck.

You can not control a portal in preview or print mode, it will always show from record 1 and up.

Posted

Actually - you can control which record will be the first in a portal. But this is done in Layout mode and can not be altered at run time.

Posted

Actually - you can control which record will be the first in a portal. But this is done in Layout mode and can not be altered at run time.

What about altering it in browse mode? Can the scroll bar position be controlled via a script? I could have a "print" button that triggers a script to 'go to preview mode', print, 'go to browse mode', scroll 10 lines, and repeat until there are no records left.

From post #2-

Usually you would print from the child records view. From here you can show to the Parent data, and you can set an option on the Body part to make a page break at every 10 occurences.

Does this mean that I would have to make a new layout based on the table that the child records are from, then add the fields from the parent records to the layout?

What do developers do for invoices when the line items portal has too many records for one page? Say you have customer and vendor info above and below the portal that you want to appear on each page and can only fit 10 line items on a printed sheet, so your layout is limited to that. What do they do when they want to print an order with 15 line items if you want the same info outside of the portal (line items) but a new view (scrolled down) of the portal?

Posted

What about altering it in browse mode? Can the scroll bar position be controlled via a script? I could have a "print" button that triggers a script to 'go to preview mode', print, 'go to browse mode', scroll 10 lines, and repeat until there are no records left.

No whenever you enter Preview or Print Mode the portal resets to whatever it was set up to in Layout mode.

Does this mean that I would have to make a new layout based on the table that the child records are from, then add the fields from the parent records to the layout?

Yes

What do developers do for invoices when the line items portal has too many records for one page? Say you have customer and vendor info above and below the portal that you want to appear on each page and can only fit 10 line items on a printed sheet, so your layout is limited to that. What do they do when they want to print an order with 15 line items if you want the same info outside of the portal (line items) but a new view (scrolled down) of the portal?

We do excactly that, and Filemaker will take care of the rest, it will print as many pages as it takes, fitted to the papersize you have chosen.

  • Like 1

This topic is 4802 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.