Ssrs Parameters

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

Solution 1:

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 *
FROMYourReportViewWHEREEmployeeIdIN (
  SELECT Id
  FROM SomeEmployeeTable
  WHERE EmployeeName = @EmployeeName
);

The @EmployeeName parameter would be mapped to the SSRS parameter.

Solution 2:

Presumably you have a one-to-many link between your Employee record and the staff numbers. Why don't you filter using the parent item?

Solution 3:

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..