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!

Group Sum 1

Status
Not open for further replies.

kingduck

MIS
Oct 31, 2002
41
EG
Hi All;
How do i sum value in a group and reset the sum for a new group. So that each group has its total beneath it?


Thanks in advance.
 
Right click on the field->insert summary->sum->check "insert summary for all groups".

-LB
 
Thanks LB for your reply
The calculate combo does not have sum in it. it has maximum , minimum, count and other stuff but no sum.

I am using crystal report for VS.NET 2002

Thanks
 
What is the datatype of the field you are trying to sum? If it is a string with numeric text, then create a formula:

val({table.string})

Then insert a summary (sum) on the formula.

-LB
 
Thanks LB. It was a numeric text

Thanks very much
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top