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 Software List by Computer/Server Name
by  Andy.S  
Go to last post Go to first unread
Last post: Yesterday at 8:06:43 AM(UTC)
Lansweeper Asset: Duplicate Serial Number (Built-in)
by  brodiemac-too   Go to last post Go to first unread
Last post: 8/5/2020 1:28:56 PM(UTC)
Lansweeper A Simple Report (or so I thought)
by  Andy.S  
Go to last post Go to first unread
Last post: 8/5/2020 11:30:45 AM(UTC)
Lansweeper Paid Report Writer Service
by  endyk   Go to last post Go to first unread
Last post: 8/4/2020 11:56:20 AM(UTC)
Lansweeper Multiple Computers per User
by  brodiemac-too  
Go to last post Go to first unread
Last post: 7/30/2020 12:43:38 PM(UTC)
Lansweeper Workstations with No AV
by  brodiemac-too   Go to last post Go to first unread
Last post: 7/29/2020 7:44:53 PM(UTC)
Lansweeper AV Audit Report
by  RC62N  
Go to last post Go to first unread
Last post: 7/29/2020 5:17:42 PM(UTC)