My rdl file has a text parameter filter defined, see the attached file Parameter, and the second attached file shows its preview.
If the (Select All) is selected, what is the value on store procedure side?
I used the following on store procedure side (@FiscalYear is parameter passed in)
select col1, col2,...
where (nullif(@FiscalYear, 'SELECTALL') is null OR FiscalYear IN ( ....)
But I always have problem to get data using the above. What is the correct way?