passing Multi values thru Parameter to a Stored Procedure

[americvish]

Hi,
Is there any way or formula to pass Multivalues thru Parameter to a Stored Procedure.

the report works fine with the single value,but with multivalues , the stored procedure is taking as null.

So, can somebody help me out in passing multivalues thru parameter to stored procedure.

thanks.

 

[briangriffin]

What is your backend database?

 

[americvish]

its oracle 10g

 

[briangriffin]

Sorry for the delay, short on time. But..

Create a container report with a multivalue parameter. Then create a formula that joins the values and adds quotes as needed - something like:

"'''" + join({?Parameter},"','" + "'''"

You'll have to play around with it to get the string in the format that your sp needs it.

Then your real report becomes the subreport, and link the formula field in the container report to the sp parameter, which is automatically created when you base the report on the sp.

Hide sections as needed, and you should be good to go.

This might be easier as a command object which calls the sp.

 

[briangriffin]

By the way, if you're using CR2008 it now will accept multi value parameter in a command object, not sure about sp's.