peterr
Posts: 5971
|
| Posted: 10/04/2005, 11:27 AM |
|
You would need to change the grid's Data Source to an SQL query that outputs the summarized information with the employee totals. I often create such queries in MS Access and copy the SQL into CCS. Or you can use an MS Access query direcly in CCS if you're using MS Access as your database.
Here is sample SQL for what you described:
SELECT departments.department_name, Sum(employees.emp_id) AS SumOfemp_id FROM departments INNER JOIN employees ON departments.department_id = employees.department_id GROUP BY departments.department_name
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
