Printing a multi-page invoice

Classic Servoy
1

I need to print multi-page invoices. What is the best way to setup a form in Servoy 3.5.x so it works correctly when doing print preview / print? I have a method that sets the foundset of the form, then puts it into print preview mode. But I can’t get the right combination to show an invoice as expected, with the order header info at the top and all the related line items in the body. I need it to also handle multiple pages if there are a lot of items on an order.

I have 2 tables: orders and order_lines.

I have a form setup with a header, body, and footer. The form is based on order_lines. I fill in the header fields using a relation (order_lines_to_orders). I have the body setup with fields Qty, Item_id, and Item_desc.

I have the form set to initialSort = order_lines.order_id.

I either get one line per page and end up with a separate page for every line item, or I get all the line items in the entire file showing up on every invoice. Arghh.

This should be easy, but I’m having a brain cramp and can’t figure it out. Thanks for any help.

2

Ok, I figured it out. I knew it should be something simple.

I ended up adding a Leading Subsummary section, added a Group By field (order_id), then clicked the checkboxes to break before new occurrences. That did the trick. Works perfectly now.