In a page report or an RDL report, you can create a multi-value parameter by selecting the Multivalue option. In a multi-value parameter, you can choose a few options from the list or simply choose 'Select all' to select all options. 
If there are large number of options to choose from, choosing 'Select all' option creates an SQL query too long for an SQL Command to run. In such a case, you can specify a value to the multi-value parameter in Value for 'Select All' option.

The following procedures take you through a step by step process of how to create a multi-value parameter and specify a value for selecting all options from the list. These steps assume that you have added a Page Report/RDL Report template to your report and have a data connection in place. See Adding an ActiveReport to a Project and Connect to a Data Source for further information.

To create a dataset to populate the parameter values

1. In the Report Explorer, right-click the Data Source (DataSource1 by default) node and select Add Data Set.
   
    
2. In the DataSet dialog that appears, select the Query page.
3. Enter an SQL query like the following into the Query text box
   
   select distinct productName from Products 
   
4. Click the OK to close the dialog. You see the data set, DataSet1, and the field, productName, in the Report Explorer.

To add a Report Parameter

1. In the Report Explorer, right-click the Parameters node and select Add Parameter.
   
2. In the Report - Parameters dialog that appears, add a name for the parameter, ReportParameter1.
3. Ensure that the Data type matches that of the field (String for ProductName).
4. Enter some text in the Text for prompting users for a value field.
5. Select the check box next to Multivalue to allow users to select more than one item from the list.
6. In the Value for 'Select All' option, enter '1'.
   

To provide a list of values for the Report Parameter

1. In the Report - Parameters dialog, go to the Available Values tab and select the From query radio button.
2. Under the Dataset field, select the dataset created previous steps (DataSet1).
3. Under the Value and Label fields, select the field productName.
4. Click the OK to close the dialog and add the parameter to the collection.

To add a dataset with a parameter

1. In the Report Explorer, right-click the Data Source (DataSource1) node and select Add Data Set.
2. In the DataSet dialog that appears, on the Parameters page, click the Add (+) icon above the parameters list and add the following to the dataset to provide values for the parameters we add to the query in step 3 below.
   Name: ReportParameter1; Value: =Parameters!ReportParameter1.Value
   Name: Parameter1; Value: =Parameters!ReportParameter1.Value
   
3. On the Query page, enter a SQL query like the following in the Query text box:
   
   SELECT * FROM products where ProductName in (?) OR '1' in (?)
   
   At run time, this query matches the selected product name and fetches data accordingly. If the user chooses 'Select all' (for which we have specified value '1'), then query after 'OR' is evaluated and data is fetched for all products.
   
4. Click the Validate DataSet icon to validate the query and to populate the Fields list.
5. Click the OK to close the dialog. You see the data set, DataSet2, and the fields in the Report Explorer.

To view the report

Place a control like a Table onto the design surface and add fields to it. View the report in the preview tab and see the Parameters in the sidebar with Select all option at the top.