Notification

Icon
Error

Keep link to items when using column names

Posted: Saturday, June 27, 2020 12:16:03 AM(UTC)
Tom Galvin

Tom Galvin

Member Original PosterPosts: 1
0
Like
I searched the forums but could not find a solution. Using the following Select statement will allow me to click on the items in AssetName column

Code:
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,


But if use a Column Name then the link is no longer available.

Code:
Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName As Computer,


What do I need to do to change the column name but retain the link in the report?

Active Discussions

Lansweeper Help Desk Workflow
by  lswanson   Go to last post Go to first unread
Last post: Yesterday at 11:12:21 PM(UTC)
Lansweeper Changing to remote scanning due to COVID
by  FrankSc  
Go to last post Go to first unread
Last post: Yesterday at 9:35:26 PM(UTC)
Lansweeper Not giving hackers the Domain Admin password / account
by  FrankSc   Go to last post Go to first unread
Last post: Yesterday at 9:27:13 PM(UTC)
Lansweeper LsAgent failing - Lansweeper SSL Expired
by  lansweeper25t34  
Go to last post Go to first unread
Last post: Yesterday at 8:33:28 PM(UTC)
Lansweeper Is there a chance to get the firewall off via Lansweeper?
by  EDV_OHZ   Go to last post Go to first unread
Last post: Yesterday at 4:57:26 PM(UTC)
Lansweeper Merge Asset button
by  KeithBecker  
Go to last post Go to first unread
Last post: 8/5/2020 9:27:54 PM(UTC)
Lansweeper Merge Two Assets or Update Based on Serial Number
by  KeithBecker   Go to last post Go to first unread
Last post: 8/5/2020 9:25:16 PM(UTC)
Lansweeper Hyper-V guest assets
by  bgstein  
Go to last post Go to first unread
Last post: 8/5/2020 5:50:24 PM(UTC)