Counting.... 1

[savok]

I have a table with the Name and ClassID fields.

I need to count how many students are in each class

How would I do this in crystal?

 

[savok]

actually what I need to find out is how many times ClassID repeats

thanks

 

[LindaC]

Hi Savoc
How about grouping by classid and then putting a count field in the group footer.


LindaC
lcastner@co.orange.ny.us

 

[savok]

Linda can you be a little more specific plz?

I have a few class codes in the table, and need to find out how many times each code repeats it self, and then display it

 

[kenhamady]

click on the classID field on the detail band.

Select "Insert-Summary" from the menu.
Set the operation to "Count".
Set the group to ClassID.

This will add the group and the count in one step. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[IdoMillet]

Savok,

I suspect that your codes are in several columns
(fields) rather than in a single field. Is that true?

Cheers,
- Ido

 

[savok]

you da man Ken! thanks