Print Page | Close Window

Multi values thru Parameter to a Stored Procedure

Printed From: Crystal Reports Book
Category: General Information
Forum Name: Talk with the Author
Forum Discription: Ask Brian questions about his books and give him your comments. Like the book? Hate the book? Have suggestions? Let me know!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4306
Printed Date: 02 May 2025 at 12:03pm


Topic: Multi values thru Parameter to a Stored Procedure
Posted By: dapowande
Subject: Multi values thru Parameter to a Stored Procedure
Date Posted: 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


Replies:
Posted By: BrianBischof
Date Posted: 23 Sep 2008 at 2:17pm
This is because CR doesn't support passing multi-value parameters to the stored procedure. Sorry.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: BrianBischof
Date Posted: 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.



-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: twinkle
Date Posted: 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
Date Posted: 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.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: twinkle
Date Posted: 25 Sep 2008 at 2:57am
Hi,
 
i am using this report within a database ...
 


Print Page | Close Window