Changes to an existing PDF report - OSCOMMERCE

We have a program, [login to view URL] that generates a listing based on input criteria of sales. Currently this report produces 3 sections (SALES, PAYMENTS and CONSIGNMENT RECEIPTS with a total page after the SALES Section), SALES - listing by date of all items for the selected vendor sold showing royalties owed or consignment owed, PAYMENTS -a section on previous payments/payments due and CONSIGNMENT RECEIPTS a section on consignment inventory received, only displays on consignment report. What we need is to add a another section to this report that gives totals for the selected period by product and totals by product group (which is the first group of characters before the dash of the product model number) As such it should display as such: Product Id Products Name Qty Total Selling Total Sale Period Type Accrued Price ABCD-DVD-101 Bolivia 10 52.90 199.94 71/2009-12-31-2009 Royalty ABCD-DVD-102 Guatemalw 10 52.90 199.94 71/2009-12-31-2009 Royalty Total ABCD 20 105.80 399.88 71/2009-12-31-2009 Royalty ============================================================================================= Total orders: 211 Previous Periods Total Accrued: $1,972.01 Total quantity: 549 Total Previous Payments: $2,830.80 Total Sale: $6,258.96 Current Period Total Accrued: $1,534.10 Total Payment Due Pending: $675.30 Total Lifetime Accrued: $3,506.10 There could be multiple product groupings for a specific vendor or just one. The totals that are below the =========== line are already generated in the report. We have many producers that need to know totals by film series so they can pay royalties out that they must pay by series. Currently our report just gives a detail listing with totals for all products and we need to add totals by product and product group before the totals. I have attached the program which contains everything you need to add this change to the program as well as a copy of the current finished report created by the current program.