CODEWITHSUNDEEP
reporting-servicesssrs-2008
Aeonstrife
Aeonstrife

Reputation: 673

SQL Server Report Filter Expressions

So I have two datasets called Employee and EmployeeData. Employee is the main dataset that is used by the report and I want to add a filter to it. The filter parameter is created as EmployeeID. Employee has columns Name, Department, Job, etc. EmployeeData has columns Name, EmployeeID, Address.

I'm trying to filter using EmployeeID on Employee so I need to do some sort of join with EmployeeData using Name as the key. This would be easy in SQL but since I'm new to SSRS, I don't know what the syntax of the expression would look like here.

Thanks

Upvotes: 0

Views: 97

Answers (1)

Eric Hauenstein
Eric Hauenstein

Reputation: 2565

Create another parameter @employeename and set it's default value to the employee name from the employeename dataset, then use that parameter to filter the Employee dataset based on the like operator and the name field. SSRS is very sensitive to parameter order, so you may need to delete and recreate them in the correct order.

Upvotes: 1

Related Questions