Using SSRS Multi-Value parameters and passing to a Stored Procedure

I was poking about the net today, in search of a way to pass a SSRS Multi-value parameter into a stored procedure. I had heard it 'couldn't be done', which are fightin' words!

I found the following article on a blog which describes a fairly simple method of doing this which even formats the multi-value parameters pretty much the same as Tessitura does, a comma separated list.

http://munishbansal.wordpress.com/2008/12/29/passing-multi-value-parameter-in-stored-procedure-ssrs-report/

In Summary:  You create a multi-value SSRS parameter which returns an id value, then in the dataset, you use the JOIN function to append the values together in a single dataset parameter.

Inside the stored procedure, the old charindex syntax we know and love works great. This means we can have the same SSRS report called from in Tessitura and from the SSRS web interface. YAY!

David