Setting the Parameter field to be a Lookup 1

[StevenK]

I have a simple report whereby I have a parameter [Param1] (that the user enters) - suppose it is the CustomerID field.
The Report selection is such that we then see all the data in a Customer table for the entered CustomerID.
The problem is that my user may not know the CustomerID off the top of their head so I want the Param1 to be a lookup against existing CustomerID fields in the table.
I've stepped through the example in the help files and can see that you can import a list (to form a lookup) against existing data entries - BUT how do I have this dynamic in the sense that if I set up this lookup today a new CustomerID entered tomorrow would not be visible for selection.
How can I make this lookup dynamic ?
Is this do-able ?
Thanks in advance
Steve

 

[dgillz]

This is not supported in any version of Crystal Reports. There is however a 3rd party product that does this, check out

http://www.millettsoftware.com.

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

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[knitwit]

How about writing a small report with the customer name and id that gives your user a list before the report with the parameter is run?

 

[IdoMillet]

Wit,

That is essentially how my DataLink Viewer works; It allows you to create reports that substitute for the static parameters in Crystal.

However, instead of forcing the user to remember to run the first report and then transfer values manually (which your approach would require), it's all integrated seamlessly when you run the main report.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com