Multiple Parameters

[kezzab]

I need to be able to use the multiple parameters option on one of my reports, however when i do this the stored procedure fails to return any records.

I suspect this is because it is passing incorrect syntax back to the SP. e.g. My IN clause will be epecting ('xxxx', 'yyyy', 'zzzz') but i suspect it is getting ('xxxx, yyyy, zzzz') and therfore not working.

Does anyone have any ideas on where this can be rectified and how?

thanks

 

[Sheco]

Try searching the SQL Server Programming area of tek-tips: forum183

You should be able to find some T-SQL written to split a string into a table variable... then you could join the variable just like joining any other table... instead of using an IN clause.

 

[kezzab]

Thanks Scheco, however using reporting services 2005 I was able to do it without having to pass the parameters to the sproc.

For the size of the dataset i'm returning this will be approriate for now.