Two Columns from para

[EscapeUK]

I have a parameter that displays a list of customer numbers for the user to choose. I would like the customer names (from a different table to be displayed next to them)

Can this be done?

 

[kenhamady]

Version of CR?
Are they launching from App or design environment? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[EscapeUK]

Version 8

Launching from design environment

 

[kenhamady]

In the design environment the only way to get a live pick list is to use the select expert, and this is limited to one field at a time.

Since you are using parameters, the pick list (called default values) will be a static list saved with the parameter field. This list can have a description stored with each value, but this has to be created and saved with the parameter, usually hand entered. It can't be read from another table.

You can import a formatted text file as your default value list, but it will still be static.

You can also create a front end in VB that allows the user to pick from live values and then pass them to the parameter in Crystal.

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[dcm]

EscapeUK: Are you using v8? This enables you to have a code AND a description for the picklist values in a parameter. I use back to back reports to build a semi-'dynamic'picklist with 2 columns this way David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner