I have 2 parameters on my SSRS report that are both multi value strings, I need to pass these multi values to a stored procedure on my MS SQL 2005 instance and then do a lookup in a table based on the values in the 2 multi values strings.
In my SSRS report's Dataset Parameters section I declare the following:
According to what I was able to find on the internet and various discussion @EE this should do the trick, unfortunately it only works half :( meaning that if I only select 1 value for each of the parameters I get data back, if I select multiple values for any of the parameters the query fails silently.
I've used the option to execute the stored proc from the Data tab on my report and no matter what combo I put into the parameters, i.e. ERROR, FATAL or 'ERROR','FATAL' etc. the stored procedure doesn't return any values.
Logs AS a
WHERE a.Logger IN(@Logger) AND a.[Level] IN(@Level)
ORDER BY a.Date DESC