SSRS - ODBC Connector to Salesforce - Multi Value Parameter Trouble RRS feed

  • Question

  • User-1313059777 posted

    I'm using an ODBC Connector to connect to our Salesforce data. I do not have the following issue in my normal SQL environment.
    In SSRS I'm trying to setup a simple multi value parameter.

    I run into an issue when I attempt to add a WHERE clause in Dataset Properties:
    EXAMPLE: WHERE Country IN (@Country)

    When I click ok I get the "Define Query Parameters" box then if I click ok again it tells me "Could not create a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct. A parameter with name "Country" is missing in parameter collection.

    Again I do not have this issue with my normal database. Also, it works when I use a filter in tablix properties but I'd rather not do it that way.

    Hopefully someone can tell me what I'm missing. Thanks in advance. 

    Monday, July 23, 2018 1:49 PM

All replies

  • User347430248 posted

    Hi Jmauras,

    Please try to refer article below and try to create multi value parameter as shown in article.

    SQL Server Reporting Services Using Multi-value Parameters

    It is possible that you missed any step cause this error.

    Let us know, Whether your issue got solved by this article or not.

    We will try to provide further suggestions to solve the issue.



    Tuesday, July 24, 2018 6:47 AM