Dynamic Default values for Parameter Fields . . .

[Evoluder21]

Is there a way to create "dynamic" default values for the parameter fields using data from the database source? I want to put all the possible values in the drop down list when the user runs the report, but I don't want them to have to manually type in what the data should be. Also, is there a way to format the data in the drop down lists? One of the items I need in the list is a year and it is defined in Oracle as simply "NUMBER" (not "NUMBER (4,0)&quot, and when it shows up in the list it looks like "2,002.00" which is not really what I need. Any help would be appreciated.

 

[Evoluder21]

I found this entry in the FAQ for Crystal 4 :

http://www.tek-tips.com/faqs.cfm?spid=149&sfid=1485&CFID=82226079&CFTOKEN=13394070

Does it still apply for Crystal 8.5?

 

[lyanch]

Believe it or not... yeppers. Crystal still does not support dynamic picklists. You can "update" the lists manually by importing the list or you can dynamically update it through VB (you would need help from someone else for that).

It turned into a "that'll be the day" Crystal lack.

Lisa