Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Better way to summarize at the bottom of a report?

Status
Not open for further replies.

geoffreyg

Programmer
Dec 6, 2000
15
US
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?
 
Insert a Cross-Tab with a Row field of Customer and a summarized field of Amount. Place the cross-tab into the report footer. Ken Hamady
Crystal Reports Training and a
Quick Reference Guide to VB/Crystal
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top