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.
This entry was posted by Jeff Miles on April 1, 2011 at 12:40 pm, and is filed under SSRS. Follow any responses to this post through RSS 2.0.You can leave a response or trackback from your own site.