Repeat group on pages

[bslaast]

I have a shipping label that prints a label per part number shipped. A shipment may contain several lines of the same or different part numbers so I am grouping on part number and summing the quantity. The total quantity shipped may be more than a box can fit.

What I need is to start a new page with the same group if the group sum is greater than they quantity allowed in each package ({@proposed_parcel_qty}).

For example, if I am shipping a quantity of 5 but only 2 fit in a package, then the first page would have a quantity of 2, the second page would be a quantity of 2 and the last page would have a quantity of 1. Currently, the report will only print 1 page with a quantity of 5.

Group on part no

Page Header: {@ShipAddress}
Details: suppressed
Group header: Sum ({CUSTOMER_ORDER_DELIV_NOTE_REP.QTY_DELIVERED}, {CUSTOMER_ORDER_DELIV_NOTE_REP.CATALOG_NO})
Group footer a: {CUSTOMER_ORDER_DELIV_NOTE_REP.CATALOG_NO})
Group footer b: barcode

Each group fits on 1 page without using any "new page after" in the section expert.

 

[LaurieHamlin]

If I understand you, you need to create a variable to count the number on each page. Reset it at the top of the page. In the details section + 1. If count > {@proposed_parcel_qty} then new page after.