SSRS – Multi Value parameter in Linked Report

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.

3 thoughts on “SSRS – Multi Value parameter in Linked Report

  1. Hi Jeff – I know this is an old post, but THANK YOU SO MUCH for the information :)

    I’ve just spent about 3 hours trying to get this to work, even copying and pasting the parameter string from another report.

    It seems to be a very clumsily designed UI, I wonder why they made it feels like a dropdown box, when you are supposed to type text into it?


Leave a Reply

Your email address will not be published.