Group summary for end of report (1 Viewer)

[jalverson]

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

 

[Kempes]

Not sure I fully understand your question but I think you would be best to try the crosstab option under the "insert" menu option.

I find this the easiest way of totalling values and is quite flexible.