SQL Server Performance Forum – Threads Archive
working with parametersHi all, I’m new to reporting services and i need help for the problem mentioned below. I’ve added a parameter with available values and default from Query. when i preview report i get the drop down list populated with lets say employee Ids,
but when i select a value from the list and say view report. It displays all the values of employees ,but instead i want to display only the data pertain to the value selected.
On the data tab where you input the sql query, your query should have a condition statement. Let’s say you have name the dropdown list name as EmployeeID,
at your query, it will be as follow:
SELECT * FROM [TABLE_NAME] WHERE employee_id = @EmployeeID