Custom Fields on Report for Helpdesk Tickets

[plangham]

I have a report that lists all tickets ever raised.

When tickets are closed we have to check which company from our group of companies the issue was raised.

I now need this report to show this info and whilst I can get it list the companies I am getting a line record for each of the companies and not just the one it was raised on.

My report is as below:

Select Top 1000000 htblticket.ticketid,
'#' + Cast(htblticket.ticketid As nvarchar) As Ticket,
htblticket.date As CreationDate,
htblticket.updated As LastUpdated,
htbltickettypes.typename As Type,
htblticketstates.statename As State,
htblpriorities.name As Priority,
htblsource.name As Source,
htblusers.name As [User],
htblusers1.name As AssignedAgent,
htblusers2.name As UserLastNote,
'../helpdesk/icons/' + htbltickettypes.icon As icon,
htblticket.subject As Subject,
htblticket.assetid,
htblcustomfieldvalues.value,
htblcustomfields.name As Company
From htblticket
Inner Join htblpriorities On htblpriorities.priority = htblticket.priority
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.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 =
htbltickettypes.tickettypeid
Inner Join htblsource On htblticket.sourceid = htblsource.sourceid
Inner Join htblusers htblusers2 On htblticket.userid_lastnote =
htblusers2.userid,
htblcustomfieldvalues
Inner Join htblcustomfields On htblcustomfields.fieldid =
htblcustomfieldvalues.fieldid
Where htblcustomfields.name = 'Company' And htblticket.spam <> 'True'
Order By htblticket.ticketid