Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
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>
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
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>
Joined: 16 Jun 2008
Location: United Kingdom
Online Status: Offline
Posts: 32
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?
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
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>
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
