Here is what I would like to do:
Inventory Part number
Sales Order 1111
Sales Order 2222
Totals for Sales Orders
Work Order 9956
Work Order 9999
Totals for Work Orders
Another Inventory Part number
Sales Order 5555
Totals etc
Work order 9997
Work order 9921
Work order 9922
Totals
Inventory part numbers, work orders and sales orders are in separate tables.
I can't figure out how to get the sales orders to be grouped together and then the work orders to be grouped together under each inventory part number. What I get is:
Part number
sales Order / work order
sales order / work order.
I have tried a bunch of different things with groups (in addition to the group on inventory part number) and adding detail sections but to no avail.
Can you please show me the way to enlightenment?
Thanks a bunch!
Inventory Part number
Sales Order 1111
Sales Order 2222
Totals for Sales Orders
Work Order 9956
Work Order 9999
Totals for Work Orders
Another Inventory Part number
Sales Order 5555
Totals etc
Work order 9997
Work order 9921
Work order 9922
Totals
Inventory part numbers, work orders and sales orders are in separate tables.
I can't figure out how to get the sales orders to be grouped together and then the work orders to be grouped together under each inventory part number. What I get is:
Part number
sales Order / work order
sales order / work order.
I have tried a bunch of different things with groups (in addition to the group on inventory part number) and adding detail sections but to no avail.
Can you please show me the way to enlightenment?
Thanks a bunch!