I have been through the forums and have had no luck, I am tying to report on time spent per technician by date where I can specify the technicians and the date.  This can be achieved easily through the report wizard for requests, the problem I have is I would like to report on Projects.

I have spent a few days trying all manner of queries from the forums and trying to coble something together but am having no success.  Please can someone help.

I'd just like a report with the below information

Project ID, Project Title, Task ID, Task Title, Owner, Time Spent, Time Spent Technician

With the time spent totalled by technician that display the time in 00:00:00 format.

I am using Servicedesk 9.0 Build 9015 and MS SQL

Thanks in advance

Will