Monday, February 18, 2013 6:55 PM
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.
Monday, February 18, 2013 7:03 PM
In the parameter properties, just have to change to allow null values.
John Bocachica | Colombia | http://jboca.blogspot.com http://www.iwco.co
Monday, February 18, 2013 8:10 PMIt doesn't work, the reports said: "The parameter cannot be blank". Any idea?
Monday, February 18, 2013 8:19 PMI 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
Thursday, February 21, 2013 1:13 AMModerator
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
TechNet Community Support