AnsweredAssumed Answered

use parameter in ssrs but get fault

Question asked by kim.zhu on Jul 29, 2015
Latest reply on Jul 30, 2015 by kim.zhu

I'm trying to use ssrs to create some report.

PI: 2012

MSSQL: 2008 r2 standard

It works fine when not using parameter. Once I used parameter in the sql, it raise syntax fault.

How can I use parameter in the sql to query from pi system?

 

Screen Shot 2015-07-29 at 2.21.13 PM.png

Outcomes