Multiple Select Parameter Only Selecting First Value

I have a SSRS report with a Parameter that lets you choose the name of an employee. The report lists their Name, Number, User ID etc.
When you select a single employee, the filter on the Dataset works perfectly. However once you select two or more employee names, it only returns the first result. 

The parameter, Field, and Filter are text. 
The Filter is EmployeeName IN @EmployeeName

Any help is appreciated. 

September 8th, 2015 9:32am

Hi,

Try this.

=join(Parameters!EmployeeName.Value,",")  as a expression in dataset properties.

Free Windows Admin Tool Kit Click here and download it now
September 8th, 2015 12:30pm

Tried this as well. Also tried it again just to make sure, Still no good. 
September 8th, 2015 4:18pm

It's a filter, not part of the query.

Set your filter to be

Expression =Fields!field.Value
Operator IN
Value =JOIN(Parameters!param.Value,",")

Free Windows Admin Tool Kit Click here and download it now
September 8th, 2015 5:29pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics