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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying Total of Fields

Status
Not open for further replies.

Superbaker

IS-IT--Management
Jun 21, 2002
91
US
I really dont know that much about crystal so hopefully I can explain this.

A report currently displays a seperate cost total for 60 different catagories. The field the total is displayed in is @TotalCost. I would like to add up all of these totals for all of the catagories at the end of the entire report. Hopefully someone can understand what I am looking for by this horrible description.

THanks
 
Share what's in @totalcost with us.

You may have to create another formula that totals these, this assumes that this formula is being reset at some group level or some such.

You don't need a formula to do subtotals and totals, right click any field in the details section and select insert summary->sum and turn on Grand Totals. You can then remove the field from the details if need be.

-k
 
The field I was talking about was @LaborTotal not @LaborCost, sorry.
This is whats in @LaborTotal

WhilePrintingRecords;

NumberVar LaborTotal;

LaborTotal;

There is a group in this report.
 
That formula does nothing but display a value for LaborTotal, I'd need to know what the formula is doing that creates the total...

Anyway, consider using standard Crystal generated summaries (Insert Summary) or Running Totals if possible, or post the formula which sets the LaborTotal variable.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top