I have a report structured in the following way
Customer Inv # Inv Amt.
=======================
Jeff 101 $40
Jeff 102 $50
Warren 103 $50
Mary 104 $50
Jeff 105 $10
Mary 106 $15
At the bottom of the report, I would like to see:
Customer Totals:
Jeff $100
Mary $65
Warren $50
What is the best way to do this?
Customer Inv # Inv Amt.
=======================
Jeff 101 $40
Jeff 102 $50
Warren 103 $50
Mary 104 $50
Jeff 105 $10
Mary 106 $15
At the bottom of the report, I would like to see:
Customer Totals:
Jeff $100
Mary $65
Warren $50
What is the best way to do this?