Using HTML Links in Reports

[peewee]

We created some customized reports and use the "hyperlink_hyp" & "hyperlink_name_hyp" in the Report to create the Links.

1.Can you create more then 1 Link per Report this way?
2. If your link is an internal link i.e to an IP-Location page it opens the link in a new tab. Can this be opened in the same window aswell

[peewee]

Works like a dream. Thanks

[Daniel_B · Accepted solution]

Multiple Hyperlinks can be added without issue. In "hyperlink_hyp" and "hyperlink_name_hyp" the last part "hyp" represents the column name. The example report below uses two hyperlinks. Hyperlinks will always be opened in a new tab.

Select Top 1000000 'Link 1 for ' + tblAssets.AssetName As hyperlink_name_Link1,
  'http://www.example.com&Assetname=' + tblAssets.AssetName As hyperlink_Link1,
  'Link 2 for ' + tblAssets.AssetName As hyperlink_name_Link2,
  'http://www.secondexample.com&Assetname=' + tblAssets.AssetName As
  hyperlink_Link2
From tblAssets