|
Hello, Is there a way in SSRS 2005 to use a stored procedure in a Dataset that accepts a multi-valued parameter? For example, I’d like to pass one or more business units to my SP, let’s say 01 & 02. Through SQL Profiler I found that what is being passed to my SP is N'01,02' My SP WHERE clause looks like the following: WERE BU IN (@parm_BUs) So at execution time I get WHERE BU IN ('01,02'). What I really want is WHERE BU IN ('01’,’02'). Thanks, Don
(comments are locked)
|
|
You want to do some reading up on splitting parameters. Jeff Moden is your best bet over at SSC, with articles such as The basic premise is to turn your multi-valued parameter into a table of values so you can then reference this is your query as a Sounds like SSRS 2005 doesn't support this functionality. In my case using a SP is a preference not a requirement therefore I think I'll place my code directly in the dataset rather than complicating things by using this cumbersome workaround. Thank you for your help, Don
Apr 23 '10 at 04:32 PM
don 2
(comments are locked)
|
