AnsweredAssumed Answered

PIOLEDB transposefunction with parameters

Question asked by HansBleijendaal on Jun 21, 2017
Latest reply on Jun 24, 2017 by John Messinger

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?

Outcomes