Parameter for record selection - returning a list

[agray123]

SQL Server - CR 8.5 using OLE_DB connection.

I created a parameter field promting string value for Travel ID - then placed it in the select expert after selecting {TRAVEL}TravelID.

Now I get my desired result of only displaying one record per entry.

However the Travel Id's look like this "Q6UJ9A0000M2"

After this report is implemented with the software there will be hundreds of these ugly strings out there.

I want to simplify the selection process - and would like to have the user first enter the traveler's name - which I can obvioulsy do with a parameter/select strategy, then I want to get the Travel Begin date - which will be done the same way - but from there - can I get a list of all travel id's to pcik from dynamically generated - or can I display a list after the travel selection taht displays a formula showing Travel ID - depart date?

I am looking for a pick list- but want it to be a dynamically updating list

 

[dgillz]

No version of Crystal offers a dynamic pick list fnctionality.

However if you check out

http://www.millettsoftware.com,

they have a great tool for this.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

 

[agray123]

I guess I had better fire up a general invoice - thanks!