K1000: Help Building Work Report by Location with Department Breakdown
I am trying to formulate a report that would give me the following layout:
Location # of Tickets Total Hours worked
If it could then nest the following under each location:
Department # of Tickets Total Hours worked
So with filling some info in:
Location # of Tickets Total Hours Worked
Head Office 40 80
HR 10 20
Accounting 30 60
Hopefully this make sense.
We use the user’s Custom 1 field for the department and the user’s location field for the location. This is updated from our AD imports. We also store this info in custom 3 and 4 in the ticket.
I have only started this project but since I have very limited SQL knowledge I thought I would get a post going before I loose what is left of my hair. ;)
As for a time frame to look at would like to be able to run this report for the last month, quarter and year.
This does not sound like a small order so many thanks in advance for any input.
There are no answers at this time