Parameter field selection list that changes with database contents

[posero]

Does anyone know how to use parameter fields in Crystal 8 so that the contents of the dropdown list the user sees to make their selection changes according to the contents of the database ?&nbsp;&nbsp;(i.e.: that the dropdown changes dynamically with the database).<br><br>Thanks !!

 

[MalcolmW]

It doesn't work that way - the best you can get is the contents of a specific database at design time.&nbsp;&nbsp;That list is saved with the report and used from then on.<br>If you use Seagate Info to run the report, Info can handle dynamic parameter lists.&nbsp;&nbsp;That is the only way (other than coding the parameter interface yourself) that I know of - please correct me if someone knows a way to do this. <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>

 

[FowlerConsulting]

Malcolm Wynden is right.

You will have to author ADO code to make the parameter prompts yourself.
I have a methodology that I use to make this read in dynamically in one page, so you do not have to author up one VB prompt page per report… if you want a hint let me know…

Steven Fowler

http://www.fowlerconsulting.com

e-Business Intelligence Experts^TM

We specialize in:
Crystal Report Authoring
Seagate Info Deployment
Data-warehouse and Data-mart Development
Infrastructure Planning
Seagate Crystal Report and Info Training