→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
peewee
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
peewee
Engaged Sweeper II
Works like a dream. Thanks
Daniel_B
Lansweeper Alumni
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