Counting Records by group

[cooh23]

Hi All,

How do I calculate a record by group?
I have 3 groups in my report:
- ActivityDate
- FunctionsID
- EmployeeID

I want to calculate how many records are in the employeeID.

Also, is there a way to number the employees? (let's say i have 7 employees, and i want each employee to have a number 1 - 7)

I don't have any entries under Detail section.

Thank you,

 

[nIGHTmAYOR]

For your eyes only here are two neat tricks :

1 - Right Click your report > Sorting and Grouping > select EmployeeID in Field / Expression > Select Yes in Group Footer
Now in EmployeeID footer add a text field where its Control Source property has the value :
=Count(*)

2 - Add a text field in detail section and name it Serial
Now add to its Control Source property the value :
=1
and in Running Sum property choose :
Over Group