I am trying to pass in a multivalue value parameter as a report parameter. I am able to preview it in the "Data" tab in Design view with the "Run" icon. On the "Preview" tab, I am able generate the data for the 2 parameters.
But, when I try to view the report, I get an error. It states, "An error occurred during local report processing. An error has occurred during report processing. Cannot add multi value query parameter '?' for data set 'EMS' because it is
not supported by the data extension."
I have found some online suggestions that recommended joining the parameters. So, on the "Parameters" tab of my Dataset, I have added =Join(Parameters!Location.Value, ", "). This is pulling the values from the other dataset I'm using.
I also tried putting the entire select in the "Parameters" tab of the Dataset, sort of like this "=SELECT <column> FROM <table> WHERE <column> in ('" & Join(Parameters!Location.Value, ", ") & "')". But, this doesn't work.
Maybe I didn't do it correctly.
I need to use ODBC connections because we need to keep our SQL environments abstracted as the reports are moved from development through to production.
View Complete Post