开发者

SSRS return blank value and regular value to function

开发者 https://www.devze.com 2023-01-15 22:33 出处:网络
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

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.
0

精彩评论

暂无评论...
验证码 换一张
取 消