We are trying to run a time spent grouped by support group. Specifically, we are looking for a report that shows the time spent on "On-Call" tickets (designated by the on-call checkbox in the ticket) but broken down by the tech support group vs the technician. Is there a way to do this? So far I've only found how to group it based on the tech, not the tech group. I'd love to be able to create this with the built in report creator, but I'm guessing it will have to be a scripted report....

This is what I was able to create with the report creator:

SELECT rctd.FIRST_NAME "Time Spent Technician",wo.WORKORDERID "Request ID",ct.CREATEDTIME "Time Spent Created Time",rctd.FIRST_NAME "Time Spent Technician",dpt.DEPTNAME "Department",std.STATUSNAME "Request Status",wo.COMPLETEDTIME "Completed Time",ct.TIMESPENT "Time Spent",ct.TOTAL_CHARGE "Time Spent Total_Charge" FROM WorkOrder wo LEFT JOIN WorkOrderToCharge wotoc ON wo.WORKORDERID=wotoc.WORKORDERID LEFT JOIN ChargesTable ct ON wotoc.CHARGEID=ct.CHARGEID LEFT JOIN SDUser rcti ON ct.TECHNICIANID=rcti.USERID LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Fields wof ON wo.WORKORDERID=wof.WORKORDERID WHERE  ((wof.UDF_CHAR10 LIKE N'%Yes%' COLLATE SQL_Latin1_General_CP1_CI_AS) AND (((ct.CREATEDTIME >= 1387692000000) AND ((ct.CREATEDTIME != 0) AND (ct.CREATEDTIME IS NOT NULL))) AND ((ct.CREATEDTIME <= 1388296799000) AND (((ct.CREATEDTIME != 0) AND (ct.CREATEDTIME IS NOT NULL)) AND (ct.CREATEDTIME != -1)))))  AND wo.ISPARENT='1'  ORDER BY 1,  qd.QUEUENAME