Some help with a large monthly report.

Hi I understand this is going to be a large report, but I have not got the experience with queries enough to produce and was hoping this community would be able to help.

We use SDP across 4 companies (Regions) and each company has seperate branches (Sites). I have 4 engineers (Technicians) and we need to produce a Timespent report for the previous month by Region, by Site, by Technician to cross charge these companies.

The details need to be pulled from any of the worklogs available: Incidents, Requests, Problems, Changes and Projects.

I currently have a Matrix report that serves the purpose well and this was easy to make, but it does not capture any of the work logs on the projects.

Please could someone help me in this.

Many Thanks
Jassen