Refresh Parameter Drop Down Lists During Runtime..

[aszejna]

I am writing a report (CR 7.0) that reports on a particular client which I have built into the report as a Parameter prompt.&nbsp;&nbsp;The parameter prompt has a drop down list of all available clients (based on browse table).<br><br>The report works fine for one database, but a problem occurs, however, when I run the report for another database (same database structure) which has different data, in that the parameter drop down list still contains the data from the old database as opposed to the new database that has just been connected to.<br><br>The question is: How do I refresh this selection list (ie: the data in the drop down list) at runtime, so that it contains the data pertaining to the newly connected database?&nbsp;&nbsp;Is there some type of refresh method specifically for the drop down list during runtime?

 

[pwesson]

I believe that list is created at design time and can not be updated to use the current database. I may be wrong and if I am, I'd love to hear your solution, as I have that exact same problem.<br><br>Paul <p>Paul Wesson, Programmer/Analys<br><a href=mailtoaul@wessoft.com>paul@wessoft.com</a><br><a href=

http://www.wessoft.com/>Paul

Wesson, Programmer/Analyst</a><br>

 

[MalcolmW]

If you run the report from Crystal Info, you can use table lookup that is refreshed at runtime.&nbsp;&nbsp;Otherwise, the list is only current as of report design time. <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>

 

[PANZON]

IN CRYSTAL INFO AS WELL YOU HAVE THE PICK LIST OPTION AVAILABLE. YOU CREATE A NEW REPORT WITH THE INFORMATION YOU WANT IN THE LIST - NO HEADERS ETC., JUST THE WHAT YOU WANT TO SHOW UP. THEN YOU SCHEDULE THIS REPORT TO RUN EVERYNIGHT AT XX:XX SO THAT IT WILL GET REFRESHED DATA AND EXPORT IT TO A TEXT FILE. YOU THEN POINT THE PARAMETER PROMPT TO THIS TXT FILE AND IT WILL REFRESH. THERE IS A KNOWLEDGE BASE ARTICLE ON THIS ON THE SEAGATE SITE.