StringList parameter - how to use in a sql query

[debraballenger]

Hi All,

I want to have a list parameter in my report for users to select multiple values from my list. And then pass this list to a sql statement for use like this: IN (@Parameter)
I have the parameter in the query defined as a varchar(1000) and the variable as a String List. I am getting the following error in the report when I render it.

Failed to convert parameter value from a StringList to a String.

Any suggestions for how to make this work?

[Alex K.]

Hello,

Please see the sample report in attachment.

Thank you.

[wayniac10]

HI Guys, The attached report does not seem to be working correctly/
there are 2 variables 1 of type string another of type int (list)
in the SQL query the syntax references the variable of type string.

I think what we looking for is how to pass a string variable of type list to a sql query.

[Alex K.]

Hello,

The report works correctly.

Thank you.