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.
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
I’m glad I could help! I agree, there are a few quirks like that within SSRS that can be very frustrating.
Thank you so much, I’ve been looking for an answer to this for ages! So simple!!!