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!
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.
精彩评论