Business Intelligence and Data Warehouse Concepts

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

In most of the reports, we use multivalue parameters and for that we can directly write sql query in a separate data sets and modify the main dataset. It works fine for BIDS and Report Server for multi value parameters. But when we need to pass parameter values from the external portal to the reports then follow below steps: 1) Create a split function in your database (Many examples are available online) 2) Create a separate dataset for multivalue parameters 3) Change main dataset to populate multivalue parameter values from split function i.e: and (param1 in             (select column_value as param1 from table(HR.SPLIT(:Param1))) OR :param1 = ‘ALL’) 4) Go to the main dataset properties –> parameter –> select multivalue parameter expression –> add     this: =Join(Parameters!Param1.Value,”,”) 5) It should work now For the URL populate multivalue paramter value list externally using sql query. I have also included 'ALL' as ...