SQL Server Performance

working with parameters

Discussion in 'SQL Server 2005 Reporting Services' started by Esha.S, Nov 10, 2006.

  1. Esha.S New Member

    Hi 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.
  2. smy New Member

    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

Share This Page