Parameter not mandatory

Question

Hello, I have three parameters in my report, but I want one of them to be no mandatory, just optional in the report. How do I do that?

Thanks in advance.

Answer 1

In the parameter properties, just have to change to allow null values.

Regards

---

John Bocachica | Colombia | http://jboca.blogspot.com http://www.iwco.co

Answer 2

It doesn't work, the reports said: "The parameter cannot be blank". Any idea?

Answer 3

I am assuming that parameter is a multi-value parameter. If this is the case, the query/dataset that you use build the list of values in this parameter, can also be used to set the default values so that when the report is ran, all the values are checked automatically and does not need to be selected.

---

Please mark as answered or vote helpful if this post help resolved your issue. Thanks!

k r o o t z

Answer 4

Hi Abernardo,

As Krootz posted, to make a parameter optional, we can just set default values for the parameter. For more information, please see:
Creating Report Parameters and Setting Report Parameter Properties

Regards,

---

Mike Yin
TechNet Community Support