fRe: Multi-value parameters

Now do you know how to take multi-value parameter array values and pass to Sql Stored Proc for summing ?

Your multi value parameter gets passed to your stored proc as a comma delimited list of values, so you can use the IN keyword in your WHERE clause, like this:

Code Snippet

SELECT SUM(prices)

FROM Products

WHERE ProductID IN (@.myMultiValuedParameter)

|||

i'm trying to do this but i'm getting an error when the report compiles saying "Conversion failed when converting the nvarchar value '4998,5043' to data type int."

I'm passing in a multivalue parameter called "empno" of value "4998, 5043" and my sql for it is:

SELECT... FROM ... WHERE empno IN (@.empno)

Any ideas?

|||I have not tried it yet personally, but I have read from other posts that Stored procs do not take more than one parameter from Reporting Services...Is this true...?