I have a manufacturing report that is grouped by manufacturing operation. Depending on the product, there can be can be one group, meaning that it only takes one operation to make the product or up to 5 operations to make an item.
At the end of each group are subtotals, Instead of having to flip through the report to find/view each subtotal, the user wants a summary for each group on the last page of the report. Since the number of groups is dependent on the item, the summary could be between 1 and 5 lines long.
How do you display the subtotal for each group at the end of the report?
Here are 2 example:
Ex 1
1 group - subtotal for group 1
Rpt Grand total
Ex 2
Group 1 subtotal of group 1
Group 2 subtotal of group 2
Group 3 subtotal of group 3
Rpt Grand Total
I appreciate your help with solving my question,
Jeff
At the end of each group are subtotals, Instead of having to flip through the report to find/view each subtotal, the user wants a summary for each group on the last page of the report. Since the number of groups is dependent on the item, the summary could be between 1 and 5 lines long.
How do you display the subtotal for each group at the end of the report?
Here are 2 example:
Ex 1
1 group - subtotal for group 1
Rpt Grand total
Ex 2
Group 1 subtotal of group 1
Group 2 subtotal of group 2
Group 3 subtotal of group 3
Rpt Grand Total
I appreciate your help with solving my question,
Jeff