Question: I am creating a parameter for my report where the Label is the employee name, and the value is their Staff No. This is fine if everyone only has one staff number, however I have a number of people who have multiple, and I need all the data to be pulled through when I select their name, so that means multiple values.

Is this possible and if so how, i have tried separating the numbers with commors but this makes the report fall over.

![enter image description here](https://i.stack.imgur.com/bOyjU.jpg)

Answer: 
You should handle this in your query. Set up the parameter to accept an employee's name, and then filter the data in the report based on a look-up of that employee:

```
SELECT *
FROM YourReportView
WHERE EmployeeId IN (
  SELECT Id
  FROM SomeEmployeeTable
  WHERE EmployeeName = @EmployeeName
);

```

The `@EmployeeName` parameter would be mapped to the SSRS parameter.
Apart from your main query, create another dataset in which get all the "Employee Names".
Go to parameter properties that have used in main query as "Employee Name" go to available values give the dataset name 2 and give value field and label fields..