I am trying to build a reports based on the below query. THis is a request for eventframe-data, see output in the screenshot.
With the where statement I can filter the data based on the asset.
But now I want te be able to filter the data with a parameter like: WHERE ts.asset = @Assetparameter.
How to do this?
When I use this query in a dataset in SRSS I always get an error message
Can someone can advice me how to deal with parameters and SRSS with this query?