SSRS TUTORIAL 5: PAGINATED REPORT (MULTI VALUE PARAMETER)

This video describes how to pass multiple parameter value for ssrs
Paginated report.
A multivalue parameter allows the user to select more than one value for the parameter from a list of available values. When you define a list of available values for a multivalue parameter, a -select all- option is automatically added to the list of values in the report parameter editor. You can use this option to select and clear all values in the list. The expression for a multivalue parameter does not differ from the expression for a single value parameter i.e., the expression begins with the Parameters keyword. For example, a parameter named VendorSelect appears as Parameters.VendorSelect.Value in the expression editor. For more information, see Using Report Parameters in Expressions.

To specify that a report parameter would accept multiple values, set the MultiValue property of the parameter to True. You can set any parameter type to multivalue except Boolean. The primary use of multivalue parameters is to allow for query restriction clauses based on a set of values.

The example below shows the use of the IN keyword in the WHERE clause of a T-SQL statement. For more information about the IN keyword or the results returned by this query, see IN Transact-SQL .

SELECT ProductID, Name, Color
FROM Production.Product