Reputation: 63
I have an SSRS report that has a hidden parameter that is based on a dataset. the parameter is multivalued and is set as the default value as well. If the dataset returns no data is there a way to suppress the message during report preview "The parameter name is missing a value" and continue to load report.
Upvotes: 0
Views: 310
Reputation: 21738
I've not tested this but I would do something like...
Allow null values on the parameter.
Then in your report check the number of selected items in your parameter and set the hidden property of a text box (with your info/warning in) to show the textbox if something nothing is selected. Set the Hidden
property to something like
=Parameters!myParameter.Count >0
Alternatively check the first value is not empty with something like
=LEN(Parameters!myParameter.Value(0)) > 0
Upvotes: 0