Found solution:
Added the following to the report view;
'<a href = "https://<<server_url>>/assetpictures/' + CAST(dbo.tblAssets.AssetID AS varchar) + '.jpg" target="_new"><img src = "https://<<server_url>>/assetpictures/' + CAST(dbo.tblAssets.AssetID AS varchar) + '.jpg" width="auto" height="25" class="rimage picbox" ></a>' AS Picture,
Replace <<server_url>> with your Lansweeper server's URL.
Don