Reports Help

[Opieos]

Hey gang:

Back to see if anyone can offer suggestions. I am trying to develop a report from my database.

What I am looking to do is have a report available for admin that will sort on each employee and then total (show) the number of cases that they have assigned to them.

I have this semi done in a columnar list/report which will list the employee and then under them list the case (and other information I would like in a report.) I am at a lose on how to get a total field for the cases (for each employee)

Thank you for any help

Opieos

[mr_vodka]

You need a summary field that counts. You should be able to create a subsummary report using the wizard pretty easily. Group on the EmployeeID field.