1

I have a SSRS report with multi select parameter option. I'm able to either select few or all. But in my scenario the parameter section itself is optional. If nothing is selected no data should come based on the parameter.

Is there a way to do that in SSRS?

Cœur
  • 37,241
  • 25
  • 195
  • 267
RMu
  • 817
  • 2
  • 17
  • 41
  • 1
    Check this out. http://stackoverflow.com/questions/24658441/how-to-allow-blank-values-for-multitple-parameters . – Anup Agrawal Dec 21 '15 at 19:34
  • @AnupAgrawal That example does not utilize multi select paramater and in my case it's multi select. So i'm not able to set null value to it. – RMu Dec 21 '15 at 19:36
  • You can do the same as suggested in that example. Allow blank/null values and modify the query to handle the blank/null values. – Anup Agrawal Dec 21 '15 at 19:38
  • @AnupAgrawal With Multi select enabled, if i check Allow Null it's throwing error "A Multi-value parameter cannot include Null values" – RMu Dec 21 '15 at 20:25
  • What about the blank value? Does it allow you to select blank value along with the multiselect? – Anup Agrawal Dec 21 '15 at 20:28
  • @AnupAgrawal It does allow blank value. – RMu Dec 21 '15 at 20:29
  • Great. Now Just update your query to accept Blank value as one of the available value and then update your query accordingly to show no data when blank value is selected. – Anup Agrawal Dec 21 '15 at 21:36
  • That works but Can i have option to not select the paramater itself in SSRS leaving it empty with a multi select parameter? Basically, I want to optionally Select a paramter – RMu Dec 22 '15 at 18:52
  • Default the parameter so select the Blank value then you do not have to do anything. – NewGuy Dec 22 '15 at 20:30
  • Agree with the @newGuy. Default it to blank. – Anup Agrawal Dec 22 '15 at 22:49
  • Still it is asking me to select a parameter value if I dont select any! :( Not sure if i'm doing something wrong – RMu Dec 23 '15 at 15:12
  • See [this answer](https://stackoverflow.com/a/49786027/7794769) for a possible explanation\solution. – stomy Apr 12 '18 at 16:50

0 Answers0