Multi values thru Parameter to a Stored Procedure

Printed From: Crystal Reports Book — Forum Name: Talk with the Author

Posted By: dapowande — 19 Sep 2008 at 6:39am

Brian:

I am struggling with passing multi values thru parameter to a stored procedure.

Passing single value works fine but when multiple values are sent, the sql query shows NULL instead of having the values as comma separated.

I'll really appreciate your input on this.

Regards,

Oladapo

Posted By: BrianBischof — 23 Sep 2008 at 2:17pm

This is because CR doesn't support passing multi-value parameters to the stored procedure. Sorry.

Posted By: BrianBischof — 23 Sep 2008 at 2:43pm

The way around this is to use a .NET/Java interface to prompt the user for the parameter values and then pass them to the stored procedure via your programming application.

Posted By: twinkle — 24 Sep 2008 at 1:15am

Hello,

I have a similar issue, where i have set up my parameter to be a multi select. so i would like to know what happens if a user selects different values whilst holding the ctrl key down - do i need to put some formula to handle this?

thanks

Posted By: BrianBischof — 24 Sep 2008 at 9:47am

What are you doing with this multi-value parameter? If you're just using it in your report, then you are okay. If you are also trying to pass it to a SQL stored procedure, then it won't work b/c Crystal doesn't support this.

Posted By: twinkle — 25 Sep 2008 at 2:57am

Hi,

i am using this report within a database ...