Report on Requests,Problems,Tasks per Technician

Report on Requests,Problems,Tasks per Technician

I would like to create a report showing, for each technician, how many Open Requests, Problems & Tasks they have.  I have reports for all Open Requests, all Open Problems & all Open Tasks but they are separate reports.  What I want is to join this information together so it shows, by Technician, the total number of Open activities for each technician.
ie:
Tech A            requests = 23, problems = 5, tasks = 10, total = 38
Tech B            requests = 9, problems = 2, tasks = 15, total = 26
etc.

I assume this requires a query report but my knowledge of constructing queries is only very basic.
Has anyone already done anything similar ?

            Related Products