Drop-down list

[GSL]

Is there a way to create a drop-down list for parameter or calculate field? We have a list of customer id and it will be great if our end users can pick a customer id from the drop-down list to run a customer report. Thanks.

[kfleming]

Not a way to do unless you write an external program and then use that as the input to R&R runtime.____Kathleen__R&R Support

[Tom_Mills]

I^ve been playing with this. If you use R&R icon builder or the Rapid Runner, the conrol file is unavailable. ____If you use a parameter file, you can query for a single item, (i.e. ID=Param1), but I have not figured out a method to Query for an "In the List" using a parameter.____My thought was that I^d have to do a Search or AT just to figure out if the ID was in the list of ID^s in the Param field. But I^ve been unable to get it to work. ____Any ideas?

[kfleming]

Here is one way to get there.____Set PARAM1 equal to "AA,BB,CC" in your control file.__In your report create a calculated field with the expression:__INLIST(ID,RIPARAM(^PARAM1^))>0____The in your query include all records where the calculated field is equal to true.______Kathleen__R&R Support

[Tom_(Guest)]

If you were trying to use pulldowns in conjunction with Rapid Runner or Icon Builder you can^t use the control file, because they create the control file.____I was trying to use a parameter file.____On the other hand I wasn^t able to get it to work either way. I built a small test dbf, rrw file and Rapid Runner set to demonstrate it. I^ll e-mail it to Kathleen to see if she wants to try and make it work.____I^ll mail it anyone that wants to try it also.____tamills@bellsouth.net____

[kfleming]

I just sent your report back to you.__I think that the source of the problem is that ID is really a 4 character field even though it contains only two characters. So the extra blanks were causing the comparison to fail. So I trimmed them out and decided to use the $ is contained in operator rather than the inlist function.__I got this to work both from the Designer and from Rapid Runner.____Kathleen__R&R Support

[Tom_Mills]

I thank Kathleen for solving this. Here^s what we found:____She used this calulated field:____LTRIM(TRIM(ID))$param1____I^d used R&R for almost 9 years and never noticed the $ operator. __ __When I played with it some more here^s what I found:__ __The LTRIM didn^t matter, although I realize it^s safer to use it just to be sure. I was also able to get it to work using the AT and the STRSEARCH, but the Inlist never worked.__ __Also it didn^t appear the quotes in the data play any part whatsoever. When it worked, it worked no matter where or if I used quotes.____I^ve also wanted a way to prompt with pull down lists. I^m working with a programmer to see if we can come up with something.