Help with clickable computer name

[scio]

Hello,
I would like to ask. We have a custom report but I don't know how to change the link on computer to clickable. It is really messy report but It is working fine if we don't touch it very much:) Don't you know please how to change it? Here it is:

Select Top 1000000 c.Computer,
w4name.Compimage As icon,
ccus.Custom2 As øada,
w4states.Statename As Stav,
c.Username As Uživatel,
ccus.Location As Umístìní,
ccus.Custom3 As Poznámka,
cpu.Name As Procesor,
mb.Product As [Zákl. deska],
w4mem.Memory As Paměť,
Case When sw.SoftwareID Is Not Null Then 'programatorske' Else Null
End As image,
ccus.Custom4 As Projekt,
ccus.PurchaseDate,
ccus.Custom1,
c.Computername As pocitac
From upgrade_tblComputers c
Left Outer Join upgrade_web40CorrectMemory w4mem On w4mem.Computername =
c.Computername
Left Outer Join upgrade_Web40OSName w4name On w4name.Computername =
c.Computername
Left Outer Join upgrade_tblCompCustom ccus On c.Computername =
ccus.Computername
Inner Join tblstate On tblstate.State = ccus.State
Left Outer Join upgrade_tblBaseBoard mb On c.Computername = mb.Computername
Left Outer Join upgrade_tblPROCESSOR cpu On c.Computername = cpu.Computername
Inner Join upgrade_web40allcompstates w4states On w4states.Computername =
c.Computername
Inner Join upgrade_tblComputersystem
On c.Computername = upgrade_tblComputersystem.Computername
Left Outer Join upgrade_tblSoftware sw On c.Computername = sw.ComputerName And
sw.softwareName = 'Microsoft Visual Studio 2008 Professional Edition - ENU'
Where upgrade_tblComputersystem.Domainrole < '2'
Order By c.Computer

Thank you very much!

[scio]

That did the trick! Thank you very much!

[Hemoco · Accepted solution]

Please try with the following report:

Select Top 1000000 c.Computer as assetname,
c.Computername As assetid,
w4name.Compimage As icon,
ccus.Custom2 As øada,
w4states.Statename As Stav,
c.Username As Uživatel,
ccus.Location As Umístìní,
ccus.Custom3 As Poznámka,
cpu.Name As Procesor,
mb.Product As [Zákl. deska],
w4mem.Memory As Paměť,
Case When sw.SoftwareID Is Not Null Then 'programatorske' Else Null
End As image,
ccus.Custom4 As Projekt,
ccus.PurchaseDate,
ccus.Custom1

From upgrade_tblComputers c
Left Outer Join upgrade_web40CorrectMemory w4mem On w4mem.Computername =
c.Computername
Left Outer Join upgrade_Web40OSName w4name On w4name.Computername =
c.Computername
Left Outer Join upgrade_tblCompCustom ccus On c.Computername =
ccus.Computername
Inner Join tblstate On tblstate.State = ccus.State
Left Outer Join upgrade_tblBaseBoard mb On c.Computername = mb.Computername
Left Outer Join upgrade_tblPROCESSOR cpu On c.Computername = cpu.Computername
Inner Join upgrade_web40allcompstates w4states On w4states.Computername =
c.Computername
Inner Join upgrade_tblComputersystem
On c.Computername = upgrade_tblComputersystem.Computername
Left Outer Join upgrade_tblSoftware sw On c.Computername = sw.ComputerName And
sw.softwareName = 'Microsoft Visual Studio 2008 Professional Edition - ENU'
Where upgrade_tblComputersystem.Domainrole < '2'
Order By c.Computer