7 Replies Latest reply on Jun 24, 2017 2:05 AM by John Messinger

    PIOLEDB transposefunction with parameters

    HansBleijendaal

      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?