November 17, 200817 yr 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
November 17, 200817 yr 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.
Create an account or sign in to comment