Hi, can anyone help with these stupid Multi-valued parameters!? Basically, the Report is doing a Search and Replace in my Query Text instead of just passing the parameter in "as is".

For example, assume the value of the parameter should be "1,2":

Select * From SomeTable Where ID IN(Select Value From dbo.ufn_Split(@Value)) Or @Value Is Null

INSTEAD, SRSS is rewriting my query to this:

Select * From SomeTable Where ID IN(Select Value From dbo.ufn_Split(N'1', N'2')) Or N'1', N'2' Is Null

Which then produces the following error:

"Query execution failed...Incorrect syntax near ',' "

Well, duh! Stop re-factoring my query!!!