TimeSpent Report

Hi

Can someone help me out, I want to run a report which shows me a list of requests and a cumulative total of time spent from the work log, even if there is no worklog entry. The reason we want to use the work log, is that this is a more accurate time of how much time we actually spend on a case, as our technicians may not be able to get access to the system to place requests on hold etc. and when they get the opportunity, they go back in an fill in the work log.

Is there any way to run this report from the report wizard so we can save it, and then use the drop-down account chooser to run if for different accounts, it would really be helpful.

At the moment we can only run a timespent report which shows requests that have a worklog entry. I looked at the SQL query and could see that if I changed the following

wot.WORKORDERID=wo.WORKORDERID INNER JOIN RequestCharges rc

to read

wot.WORKORDERID=wo.WORKORDERID LEFT JOIN RequestCharges rc

it gives me the desired output (apart from a cumulative total for the worklog if it has multiple entries), but I cannot use the account drop-down chooser to choose the account or any other cool features or formatting from the report wizard.

Can anyone help me out?

Dale