Passing multiple values for a single parameter in Reporting Services

by

Although John Sansom’s solution works, there’s another way to do this, without having to use a potentially inefficient scalar valued UDF.
In the SSRS report, on the parameters tab of the query definition, set the parameter value to 

=join(Parameters!<your param name>.Value,",")

In your query, you can then reference the value like so:

where yourColumn in (@<your param name>)

More Related Contents:

  1. Parameterize an SQL IN clause
  2. including parameters in OPENQUERY
  3. Left Outer Join Not Working?
  4. How to set table name in dynamic SQL query?
  5. Pass table as parameter into sql server UDF
  6. How to use parameters “@” in an SQL command in VB
  7. Sql PIVOT and string concatenation aggregate
  8. Can we pass parameters to a view in SQL?
  9. “Order By” using a parameter for the column name
  10. divide by zero/null workaround in SSRS 2008 report
  11. Query for getting value from another record in same table and filter by difference greater than a gap threshold
  12. how to remove time from datetime
  13. How do I format date and time on ssrs report?
  14. sql query if parameter is null select all
  15. Check if a parameter is null or empty in a stored procedure
  16. Parameterise table name in .NET/SQL?
  17. Call stored procedure with table-valued parameter from java
  18. Need SQL Script
  19. to select all the employees who have joined most recently under king
  20. How do I use parameters in VBA in the different contexts in Microsoft Access?
  21. Query with LEFT JOIN not returning rows for count of 0
  22. How do I find duplicate values in a table in Oracle?
  23. How to use a calculated column to calculate another column in the same view
  24. Query for element of array in JSON column
  25. sql query distinct with Row_Number
  26. SQL SERVER: Get total days between two dates
  27. TRANSFORM and PIVOT in Access 2013 SQL
  28. How to select records with maximum values in two columns?
  29. adding primary key to sql view
  30. Postgres: convert single row to multiple rows (unpivot)

Leave a Comment