Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using dropdownlist to pick value and send as parameter to Sql query

Status
Not open for further replies.

sajisher

Programmer
Dec 3, 2003
45
US
Hi All,

Using Crystal Reports 9.2. when the report is run, I need to display a dropdown list of managers and when a manager is selected from the list, pass it as parameter to the query and retrieve the rows. The manager needs to be picked from table at runtime.

I was googling and see this could be done dynamically using CR X1. With 9, I believe it has to added statically or use a text file to import. but these 2 methods needs to be updated whenever there is change in manager names. Anyone has some thing to share on this or how dynamically it may be achieved, will appreciate..

-saj
 
I not sure if you can really do dynamic parameters with 9.2. I know you can with XI and newer (I do not have 10 installed anymore and do not remember).
 
Thaks kray for sharing.

Anyone has done/achieved this please..

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top