Assetname not clickable

[msbGroenhout]

Anyone have any idea why the assetname in the report below is not clickable? Followed advise on old thread to remove the alias. Works for most reports just not this one. Any help appreciated.


Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetName,
tsysOS.OSname As [Operating systeem],
tblAssets.Domain As Domein,
tblADComputers.Description As [Omschrijving in AD],
tblSoftwareUni.softwareName As Applicatie,
tblSoftware.softwareVersion As Versie,
tblSoftwareUni.SoftwarePublisher As Leverancier,
tblSoftware.Installdate As Installatiedatum,
tblSoftware.Lastchanged As [Laatst gewijzigd],
tblAssets.Lastseen As [Laatst gezien],
tblAssets.Lasttried As [Laatste scanpoging],
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 /
24))) + ' days ' +
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 %
24))) + ' hours ' +
Convert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) % 3600 /
60))) + ' minutes' As Uptime
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Order By tblAssets.AssetName,
Applicatie,
Versie

[David_G · Accepted solution]

It is correct that when you want to make an assetname clickable, you will have to make sure that there is no alias for tblAssets.Assetname. An additional requirement to make the assetname clickable is to include tblAssets.AssetID to your report. The AssetID will not be visible in the output of the report but will make sure that the assetname becomes clickable.