Select All as default value for Multivalue parameter in SSRS

Select All as default value for Multivalue parameter in SSRS

In order to Set Select All as Default value for Multivalue Parameter in SSRS Report. The best way is 

like set default values of Parameter same as Available values and in Dataset of Parameter add a where condition where ColumnName is not Null .

This is the same column which u are using as Parameter in your value field.

In order to explain in a more better way .

We will create a Dataset and a Paratemeter.

--Parameter Dataset query

--DSTEmployee

select empid,empname from employee

Add Parameter

--Employee

Parameter Properties

--Allow Multiple Selection

--Available Values Tab

-From DSTEmployee

Label field-Empname

Value Field-EmpName

--Default Value Tab 

-From DSTEmployee

Value Field-EmpName

Ok

Now in order to add Select All as Default value add a where condition in your query where Empname is not Null like below

--DSTEmployee

select empid,empname from employee where EmpName is not null

Preview the Report-Report will have Parameter Default value as Select ALL EmployeeName.