Joined: 05 Jun 2008
Online Status: Offline
Posts: 35
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?
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
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.
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
