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

How to count the records per group

Status
Not open for further replies.

wmbb

Technical User
Jul 17, 2005
320
NL
How to count the records per group ?
I have grouped our customers per department.
How do I count the customers per department and display this number in the group-section ?
 
I already found the way to do it.
I've created a formula-field an used this to insert a summary.
 
You don't need a formula. Right click on the customer field->insert summary->count or distinctcount (if a customer appears more than once).

-LB
 
Thank you for your response.
You're never to old to learn !
 
The use of Crystal's automated totals is outlined at FAQ767-6524. Lots of other interestion options.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top