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

  • What can cause an EntityCommandExecutionException in EntityCommandDefinition.ExecuteStoreCommands?
  • How to improve performance when deleting entities from database?
  • Update table from UDF results
  • Failed assembly deploy due to non-matching SIDs
  • How to Consolidate Users with the Same Name Under One ID
  • SQL Server 2005: Order with NULL values at the end
  • enter image description here

  • Why do SQL Server Scalar-valued functions get slower?
  • Select count(*) from result query
  • How to find list of tables used in stored procedure without “With (nolock)” words
  • How to connect to sql server database via LAN
  • Install a certificate (SSL Encryption) on SQL Server 2005 Express
  • SQL Server Server query - Count distinct DateTime field
  • 3 Solutions collect form web for “SSRS Parameters”

    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.

    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?

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

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.