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
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
But if use a Column Name then the link is no longer available.
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?