What I would like is a report that shows time spent on requests as well as tasks.

So far I'm able to create a report of the following I'm happy with.

Request ID

Assigned Technician

Requester

Subject

Time Spent

Time Spent Description

Request Status

SELECT "rctd"."FIRST_NAME" AS "Time Spent Technician", "wo"."WORKORDERID" AS "Request ID", "ti"."FIRST_NAME" AS "Assigned Technician", "aau"."FIRST_NAME" AS "Requester", "wo"."TITLE" AS "Subject", "ct"."TIMESPENT" AS "Time Spent", "ct"."DESCRIPTION" AS "Time Spent Description", "std"."STATUSNAME" AS "Request Status", "rcode"."NAME" AS "Request Closure Code"  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 "SDUser" "sdu" ON "wo"."REQUESTERID"="sdu"."USERID" LEFT JOIN "AaaUser" "aau" ON "sdu"."USERID"="aau"."USER_ID" LEFT JOIN "WorkOrderStates" "wos" ON "wo"."WORKORDERID"="wos"."WORKORDERID" LEFT JOIN "SDUser" "td" ON "wos"."OWNERID"="td"."USERID" LEFT JOIN "AaaUser" "ti" ON "td"."USERID"="ti"."USER_ID" LEFT JOIN "RequestClosureCode" "rcode" ON "wos"."CLOSURECODEID"="rcode"."CLOSURECODEID" LEFT JOIN "StatusDefinition" "std" ON "wos"."STATUSID"="std"."STATUSID" WHERE  (("rctd"."FIRST_NAME" COLLATE SQL_Latin1_General_CP1_CI_AS = N'Williams, Casey') AND ((("wo"."CREATEDTIME" >= 1556859600000) AND (("wo"."CREATEDTIME" != 0) AND ("wo"."CREATEDTIME" IS NOT NULL))) AND (("wo"."CREATEDTIME" <= 1556945999000) AND ((("wo"."CREATEDTIME" != 0) AND ("wo"."CREATEDTIME" IS NOT NULL)) AND ("wo"."CREATEDTIME" != -1)))))  AND wo.ISPARENT='1'  ORDER BY 1, 2

The wizard does not seam to be very robust with tasks however.

What I'd like to see is another group which included time spent on each project task with columns for milestone and project ID if applicable

And a third group which includes time spent on tasks that are associated with requests or associated as well

I've seen other requests for this but everything I'm finding is for PGSQL or is over 5 years old.

I'm including a mockup of the general output I'd like to get.