Optional multi-valued parameters in SSRS

by

Have a look at this article on Passing Multivalued parameters.

Basically the above link contains a workaround to meet your requirement for an optional multivalued parameter. The steps to achieve this are as follows:

  1. Replace “ALL” with ” ” (BLANK) in the parameter’s dataset query.
  2. Assign -1 as default parameter value for your multivalued parameter.

More Related Contents:

  1. How to get rid of blank pages in PDF exported from SSRS
  2. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports are blank in Safari and Chrome
  3. Changes to parameter not showing on Report Server after deployment
  4. sql server convert date to string MM/DD/YYYY
  5. Reporting Services permissions on SQL Server R2 SSRS
  6. divide by zero/null workaround in SSRS 2008 report
  7. SSRS 2008 R2 – SSRS 2012 – ReportViewer: Reports in Safari/Chrome but works fine in Firefox/Internet Explorer 8… why?
  8. Need help in calculation using two Datasets using Expression SSRS
  9. How do I format date and time on ssrs report?
  10. Deleting duplicate record in SQL Server
  11. SSRS Conditional Formatting Switch or IIF
  12. Passing Credentials to Sql Report Server 2008
  13. Pivot a table in reporting services?
  14. Programmatically Export SSRS report from sharepoint using ReportService2010.asmx
  15. Access Page number in report body In SSRS
  16. Select query to remove non-numeric characters
  17. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  18. Connecting to MS SQL Server with Windows Authentication using Python?
  19. CASE WHEN statement for ORDER BY clause
  20. Varchar variable is not working in WHERE clause
  21. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  22. Tablix: Repeat header rows on each page not working – Report Builder 3.0
  23. A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)
  24. SQL Server Configuration Manager cannot be found
  25. SSRS – How to build a simple multi-column report?
  26. SSRS – How to continue data to next column?
  27. SSRS distinct lookupset function
  28. Using IF ELSE statement based on Count to execute different Insert statements
  29. move cells left in sql if left contains null and right contains value
  30. How to return default value from SQL query

Leave a Comment