i'm not an SSRS guru but in the past the behavior of making a parameter multi-select would pass a comma delimited string.
ie. selecting red and blue and green would give you 'red,blue,green' causing one to have to use some form of string split.
However, I am working with a report that is passing the multi-select parameter as N'red',N'blue',N'green' which doesn't work in my string split function but can be used with a simple IN (@parameter).
I haven't seen this before and i can't see anything wonky in the report definition that would make me think this was somehow intentionally done. Anybody have any ideas as to why or how this is happening?
edit: the developer thinks it might be due to his newer version of reportbuilider/BIDS/VS but I haven't seen anything about a change to feature online.
- This topic was modified 1 month, 1 week ago by Kimberlin.