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