Counting Occurences of Values

[plarson3]

Is there any way to count the occurrence of each value in a certain field in a report, when you don't know what the values are going to be? And then show the total count for each of those values at the end of the report?

Lets say its a Name field, and the values pulled into the report could be any name in the book. Assuming only 3 names are in this particular report, the desired result would be something like:

Joe - 5 occurences
Jim - 3 occurences
Bob - 2 occurences

 

[synapsevampire]

Use Insert->Group and select the name field.

Place the Name field in the details, right click it and select Insert->Summary-Sum and select for the group section Name.

-k

 

[IdoMillet]

Sure. Just insert a CrossTab where rows are the field and the data is a count.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[plarson3]

Thanks to both of you. Both good options.

I am especially loving the crosstab. Had never played with them for that purpose before. Will solve many other issues as well.