SSRS return blank value and regular value to function

Question

In SSRS I have a parameter that is populated from a multi-value list which allows a blank value.

When I select just the blank value it returns unit 123

When I select just "New" it returns unit 987

When I select both owner "New" and the blank value it only returns 987.

Any ideas? Does SSRS not allow you to pass the blank value and a normal value?

Thanks!

Answer 1

Think about what you are asking. SSRS uses arrays to manage multi value parameters. I would have to see the query to completely understand it but

• You can have an empty array
• You can have an array with one item
• But you cannot have an empty array with one item.