James
James

Reputation: 63

SSRS hidden parameter based on dataset returns no data suppress default message

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

Answers (1)

Alan Schofield
Alan Schofield

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

Related Questions