You can translate the question and the replies:

SSRS Multi Value Parameter

Hi, How to create a multi-value parameter in SSRS? In MSsql I do this sql Select * from table1 where column1 in (@values) But when I do the script below on Denodo Select * from table1 where column1 in (?) it returns error. Any Idea on how to pass multi value parameter with SSRS?
user
18-09-2017 01:19:11 -0400
code

1 Answer

Hi, When connecting to Virtual DataPort from SSRS, it is possible to parameterize a query using the ‘?’ character. Only unnamed parameters can be used to parameterize the query as named parameter(@) are not supported. If I need to pass multiple values using “IN” operator in a parameterized query, then I would define the query using “OR” operator with the ‘?’ character in the Dataset. ``` SELECT field1, field2 FROM <Database.View_name> WHERE field1 =? or field1 =? or field1=? or field1=? ``` For more information have a look at the section “Setup (SQL Report Builder parameterized query) ” in the Knowledge Base article [How to access Denodo Virtual DataPort from Microsoft SQL Server Reporting Services](https://community.denodo.com/kb/view/document/How%20to%20access%20Denodo%20Virtual%20DataPort%20from%20Microsoft%20SQL%20Server%20Reporting%20Services?category=Northbound+Connections). Hope this helps you.
Denodo Team
19-09-2017 01:58:08 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here