Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper
Is there any way to make the notes field format nicely when the report is exported to excel? The "Body"(first note) field contains html tags that do not display correctly. Some of the tickets display correctly in the report view but others start with a <p> tag
<div> <p style="margin: 0px;">Hi Josh, </p> <p style="margin: 0px;">...

we have the following report that gives us the body of the ticket and our custom resolution and closure field:

Select Top 1000000 htblticket.ticketid, As CreationDate,
htblticket.updated As LastUpdated,
htbltickettypes.typename As Type,
htblticketstates.statename As State, As Priority, As Source, As [User], As AssignedAgent,
(Select Top 1 htblnotes.note From htblnotes
Where htblnotes.ticketid = htblticket.ticketid Order By As body, As closureID, As Resolution
From htblticket
Inner Join htblpriorities On htblpriorities.priority = htblticket.priority
Inner Join htblticketstates On htblticketstates.ticketstateid =
Inner Join htblusers On htblusers.userid = htblticket.fromuserid
Left Join htblagents On htblagents.agentid = htblticket.agentid
Left Join htblusers htblusers1 On htblusers1.userid = htblagents.userid
Inner Join htbltickettypes On htblticket.tickettypeid =
Inner Join htblsource On htblticket.sourceid = htblsource.sourceid
Left Join htblticketcustomfield As resolution On htblticket.ticketid =
resolution.ticketid And
resolution.fieldid = (Select htblcustomfields.fieldid From htblcustomfields
Where = 'Ticket Resolution')
Left Join htblticketcustomfield As closure On htblticket.ticketid =
closure.ticketid And closure.fieldid = (Select htblcustomfields.fieldid
From htblcustomfields Where = 'Closure ID')
Where > GetDate() - 30
Order By closure.ticketid