Passing list as a parameter

damianmrowinski

Hi,

I cant pass parameters to the report . My data source in Fast reports is like this"

'select value from orders where order in (@parameter)'

In VS I have the code:

 rp.SetParameterValue("dt", "'Order1','Order2'");

And report is empty.

Everything works fine, if I use only one order as parameter, like this  rp.SetParameterValue("dt", " 'Order2' ");

It's like FR has some issues with SQL "in" .

Do you have any ideas how to fix it ?