cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
brigmill
Engaged Sweeper III
Greetings,

I have a report that shows all tickets, ID's, time worked, agent worked, etc., per month. It's a great end of the month report to run to see how many tickets we've all worked and closed for that time period. The only things I'd like to change are adding the totals for each individual agent and the total number of tickets at the end of the report.

Related, I'm wondering if the reports can be formatted at all, such as putting a line of space between each agents chunk of tickets to make it easier to examine.

I made an edited jpeg with some fields blurred/pixelized for privacy and the red highlighted area are the things I'm hoping to add. Currently I'm having to export to excel to make the changes, but I was hoping to be able to automatically email out of lansweeper in a similar way to avoid all the extra work.
1 REPLY 1
brigmill
Engaged Sweeper III
Sorry, forgot the report...

Select Top 1000000 htblticket.ticketid As ID,
htblticket.subject As Subject,
htblticket.updated As [Closed Date],
Sum(htblnotes.timeworked) As [Time Worked (Minutes)],
htblusers.name As Agent,
htbltickettypes.typename As [Ticket Type],
DatePart(mm, htblticket.updated) As Month,
DatePart(yy, htblticket.updated) As Year
From htblticket
Inner Join htblnotes On htblticket.ticketid = htblnotes.ticketid
Inner Join htblagents On htblagents.agentid = htblticket.agentid
Inner Join htblusers On htblusers.userid = htblagents.userid
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Inner Join htbltickettypes On htblticket.tickettypeid =
htbltickettypes.tickettypeid
Where DatePart(mm, htblticket.updated) = 10 And DatePart(yy, htblticket.updated)
= 2016 And htblticketstates.statename = 'Closed'
Group By htblticket.ticketid,
htblticket.subject,
htblticket.updated,
htblusers.name,
htbltickettypes.typename
Order By Agent