The issue was resolved via email:
In our report builder we've built in the functionality for tblassets.assetname to generate a clickable link, but this requires the following to be true:
- tblAssets.AssetID is added to the report and has no alias.
- tblAssets.AssetName is added to the report and has no alias.