I had been trying to get a multi valued parameter into a linked report for the longest time, and when running the report all I would get was an error, “The %variable% is missing a value”.

I just couldn’t figure it out, but it was just me being dumb. The answer is really quite simple:


I was trying to enter my values like this:

value1, value2, value 3


But what you need to do is enter them separately on a different line:


Then SSRS will make a comma delimited list of them for you.