great tips!

you can also convert the array send by reporting services with this code in your stored procedure.

SET @MyArray= Char(39) + Replace(@MyArray,',',Char(39)+','+Char(39)) + Char(39)

if you choose the following value in RS : XXX,YYY,ZZZ

RS send it like this to the stored procedure : 'XXX,YYY,ZZZ'

With this code, the array is transform as 'XXX','YYY','ZZZ'

You can now use it in the query.

Olivier Moreau (Neos-SDI)

http://www.omrbi.com