Similar to this question: link
However I have already mastered that. My problem is a new report we just added at work has values for parameters (i.e.:10-New, 20-Cancel, 30-Complete). For the life of me, I cannot figure out how to pass multiple values for the same parameter. (so from the previous example, choosing 10-New and 30-Complete as values for the parameter).
Can this be done? And if so, how?
I believe you do it the same way as any other report, you just comma separate your list (i.e. 10,20), which is why you need a function to split your comma separated string into a table for your where clause (sounds like you've already got this covered)
If you are passing mutiple values to a paremeter, first make sure the parameter is marked to allow multiple values.
Then in your query make sure you use some sort of split function to separate out the string.
You don't have to split it. You can do the following...
Ensure that the first, and last values in the comma-delim string are enclosed by quotes (I use a udf to do this)...
IF CHARINDEX(',', @Param) <> 1 SET @Value = ',' + @Value
IF CHARINDEX(',', REVERSE(@Value)) <> 1 SET @Value = @Value + ','
Then, enclose yur field that will be filtered in commas and wild-card expresion and use a LIKE comparison to filter your clause...
SELECT t.Field1 , t.Field2 FROM dbo.Table1 t WHERE '%,' + t.Field + ',%' LIKE @Parm
Works like a dream on any string fields, but can get tricky with dates and integers, etc. You will then have to also CAST the field you are filtering to a VARCHAR.