Hi

We have created a report that shows us each department and how many requests they are putting in with the full count at the end, we would like to sort the count to have the highest on the top.

This is the query -

SELECT sdo.NAME "Site",dpt.DEPTNAME "Department",wo.WORKORDERID "Request ID" FROM WorkOrder wo LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID WHERE (wo.ISPARENT='1')

regards

Adam