I have 3 multivalued parameters in my report.Out of them 2 are optional. Is there any way to get the results in the report with out selecting any from the 2 optional parameters.
My stored proc checks the mulivalued parameters as (States IN (SELECT * FROM Split(@State,',')))
I have done this for a single valued parameter with WHERE CustomerId = @CustId OR @CustId IS NULL.
WorkAround: I selected 'Allow null value', it is throwing this error "A multi-value parameter cannot include null values"
Can anyone point me in the right direction?
In the Report Data pane, expand the Parameters node, right-click the report parameter that was automatically created for the dataset parameter, and then click Parameter Properties. In the General tab, select Allow multiple values to allow a user to select more than one value for the parameter.
In order for Select All to be the default option, the Available Values dataset must contain at least 2 columns: value and label. They can return the same data, but their names have to be different. The Default Values dataset will then use value column and then Select All will be the default value.
Have a look at this article on Passing Multivalued parameters.
Basically the above link contains a workaround to meet your requirement for an optional multivalued parameter. The steps to achieve this are as follows:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With