Sunday, October 27, 2013

Passing multi value parameters to DB2 query is SSRS

Hi Jaliya,


Please make sure that the WHERE clause on your query like:

="SELECT * FROM TableName WHERE ColumnName IN('" & Join(Parameters!Parameter1.Value,"','") & "')"


Here is a similar issue with yours, please see:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/6852d441-1272-4fc7-b61c-7f04b004378f/rs2005-multi-value-parameter-with-db2?forum=sqlreportingservices


Regards,

Charlie Liao


If you have any feedback on our support, please click here.




We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.

Thanks for helping make community forums a great place.


No comments:

Post a Comment