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.
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?
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: