URL in report data

[ghelpdesk]

Hi Support,

Just wondering if it is possible to build a working http link as a report data field - similar to the automatic URL creation for some fields such as assetid, ip location etc.

We are creating a report and would like to then place a link in one of the columns that uses the IP address of the row. ie: 'http://' + IPAddress

But presently it just returns as a text field only.

Many thanks,

[Karel_DS · Accepted solution]

In our latest versions this is possible by use of the following syntax:

Select Top 1000000 tblAssets.AssetName As hyperlink_name_AName,
'http://' + Cast(tblAssets.IPAddress As nvarchar) As hyperlink_AName
From tblAssets

Where 'AName' is the name you want to give to your column, 'hyperlink_AName' is the hyperlink itself, and hyperlink_name_AName is the columnvalue you want to show instead of the link.