‎02-04-2016 10:40 AM - last edited on ‎11-09-2022 11:27 AM by Mercedes_O
Hello,
I have created a custom report and would like to make clickable on counts.
Would be great if I can just click on 'count', like picture below and get result with status stock in that country (custom3).
Select Top 1000000 tblAssetCustom.Custom3 As Country,
Count(tblAssets.AssetID) As Count,
tblState.Statename As State
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Where tblAssetCustom.Manufacturer Not Like 'VMware%'
Group By tblAssetCustom.Custom3,
tblState.Statename
Having tblState.Statename Like 'stock'
Order By State
Thanks
Solved! Go to Solution.
‎02-04-2016 02:35 PM
‎08-11-2017 11:55 AM
‎02-16-2016 07:02 PM
‎06-17-2022 01:08 AM
Susan.A wrote:
Just an FYI for everyone: you'll notice that some fields (model, software etc.) are clickable within report results, but these links are hard coded into the software. To create your own links, you would have to add a parameterized query to the tsysdbobjects database table and then reference this query in your main report with the hyperlink feature.
‎02-04-2016 02:35 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now