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 to “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?

    Jennifer

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.