Last post Jul 24, 2018 06:47 AM by Deepak Panchal
Jul 23, 2018 01:49 PM|jmauras|LINK
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.
Jul 24, 2018 06:47 AM|Deepak Panchal|LINK
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.