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.
Tech A requests = 23, problems = 5, tasks = 10, total = 38
Tech B requests = 9, problems = 2, tasks = 15, total = 26
I assume this requires a query report but my knowledge of constructing queries is only very basic.
Has anyone already done anything similar ?