Does replacing the IN with inner join with temp table handles multi valued values also?
Can you please explain with an example?
You can join your selected values together by using the following code in SSRS before passing it to the stored procedure...
JOIN(Parameters!MultiValParam.Value, ",")
Note: You can increase the size of the variable to include large number of values if the value of 8000 shown in the example is not enough and truncation occurs.
BI Developer
SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
Please visit... ApplyBI