Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Static Parameter with Multiple Values Post Reply Post New Topic
Author Message
OKsoccer24
Newbie
Newbie


Joined: 05 Jun 2008
Online Status: Offline
Posts: 35
Quote OKsoccer24 Replybullet Topic: Static Parameter with Multiple Values
    Posted: 28 Aug 2009 at 12:26pm
CR XI R2

I have a static parameter with it allowing multiple values.  The problem is the my customer wants to enter around 30 to 50 values.   The values will be different each time and is out of 3000 possible values so dynamic is out of the picture.   Is there a faster way to enter values in a parameter?
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 31 Aug 2009 at 6:45am
if they know the values, you can have them enter a comma delimited string and then you can check if the value is in the string, or you can break the string into an array and check if it is in the array, or you can pass it to your stored proc and have a helper function that will split it and return a table you can join against.
 
I am sure that there are a couple more ways to get it done, but those are the ones that come to mind.
 
HTH
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.