CODEWITHSUNDEEP
sqlvisual-studioreportingservices-2005reporting-services
user380432
user380432

Reputation: 4779

SSRS return blank value and regular value to function

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!

Upvotes: 1

Views: 395

Answers (1)

jimconstable
jimconstable

Reputation: 2388

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.

Upvotes: 1

Related Questions