Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Multi value Parameters and Stored Procedures Post Reply Post New Topic
Author Message
moleary
Newbie
Newbie


Joined: 06 Feb 2008
Location: United States
Online Status: Offline
Posts: 28
Quote moleary Replybullet Topic: Multi value Parameters and Stored Procedures
    Posted: 22 Apr 2009 at 7:25am
I'm working in 8.5 and I'm curious if you use multi value parameters with stored procedures and how? when I pass the value to crystal I can't edit the parameter, the allow multivalue is greyed out.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 23 Apr 2009 at 6:30am
depends on how you getting the parameters.  I am assumming that you are entering the multivalued parameter from the Crystal parameter input page.  If so there are a couple of ways to deal with it.
 
1) don't pass the parameter the stored proc, let it return too many records (this requires modifying the stored proc) and then filter the results in the Record Selection Formula section by checking if the returned value is in the array of selected values.
 
2) pass in a delimited string to the stored proc and let it parse the values and filter that way. So for a list the user might enter a comma delimited string.
 
Again, I am assuming that by multivalue you mean a user can select something like mulitple divisions in a company.
 
Hope this is on the right track.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.016 seconds.