Help with a custom Report Query
I would like to be able to produce a report each month (emailed out 1st of the new month) that lists out all the calls raised last month with there status eg open, closed, with supplier etc. Plus listing all calls that are still outstanding(open, with supplier, hold) from previous months. At the moment i have to run two reports for each department but would like this combined into just the one report.
Anyone able to help with the query?
The heading i would like are:
Request ID, Requester, Priority, Subject, Resolution, Request Status, Technician, Completed Time.
Thanks
Duncan
Anyone able to help with the query?
The heading i would like are:
Request ID, Requester, Priority, Subject, Resolution, Request Status, Technician, Completed Time.
Thanks
Duncan