Estimate only printing one page when I have more then 20 line items

[Tore2ga]

I have an estimate that has more than 20 line items but when I print it Im only getting the first page not multiple pages with all my line items.  So how can i get my estimates and invoices to print all line items?

[LaRetta]

Hi,

 

Welcome to FMForums!

 

Print from the LineItems table using a List view.  The Body would be the line item with a leading part (known as 'grouped by') based upon LineItem::InvoiceID with page break on this leading part.  Place the client and invoice fields from your Invoices table and Clients table within this leading part and be sure to sort by your break field (the field defined in your leading part).  Read up in FMHelp on creating reports and you can search here for examples of Invoices.

 

If you get stuck, let us know.  :-)

[Tore2ga]

Thank you I think I posted this in the wrong forum.  

[Lee Smith]

Not a problem. This is the right topic area for now, because you’re using version 13, unless you want ms to move it move to a different topic better fits your question.

 

Let me know by Private Topic.

[Tore2ga]

Im using Fm starting point and my estimate is only printing one page so if I have more than 19 line items its not printing  more than one page

[Lee Smith]

I wish you would have mentioned this before

Im using Fm starting point

because FM Starting Point can better answer your questions because they know it better.
 

 

This topic has been moved from "FileMaker 13 General Discussion" to "FM Starting Point - General Discussions”

 

Lee

[Richard Carlton]

Hi Torega2,

 

LaRetta's method is one way of doing it, however, it won't necessarily make a good and pretty multi-page Invoice/estimate, etc.

 

We are actually making a multi-page document for the TimeSheet print out... for our latest release... which will be coming out in the next week or so.  

 

Our process is to extend the length of the Layout to... 2 pages.   Then one Page 2... at the top put a small sized summary of who the document is for, etc... then add a portal for Page 2... but make sure you change the Portal Rows it displays.

 

When you double-click a Portal you have the options of specifying the records that portal will display.  Most people don't notice this.  For Page 2...the portal you setup should display the records AFTER the records displayed on Page 1.

 

- Richard

 

 

[Lee Smith]

I deleted your duplicate post. Please do not multiple post your questions. If you have questions about this action, please contact me via Private Message.

Lee

[Tore2ga]

RIchard I did what you suggested and now it will print 2 pages when I only have a few line items in the invoice?   is there not a way to only print multiple page invoices when my line items exceed the 19 line items 

[Richard Carlton]

Hi Tore2ga,

 

So you need to do a calc of the total related line items. Its an IF statement If ( sum(relationship of lines items::id_constant) > 19)) ; then Print 2 page layout... else print one page layout.

 

- RC