In some cases as per the requirements you will need to add 'ALL' as an independent parameter value (not a multivalue parameter) 1) Create a new dataset to populate parameter values Ex: select distinct city from table1 where city is not null union select 'ALL' as city from dual order by 1 2) Modify your main dataset query Ex: where (city = :city or 'ALL' = :city) Thank you
-Make better business decisions