Sunday, March 11, 2012

Crystal report parameter pick list

I'm trying to read a database and show the selected records in a pick list for a parameter in a crystal report. i've attached the database to the report and selected the database and field on the 'Set Default Values' screen of the parameter. But the records in the table are not being shown as a list to choose from.
What am I missing?What version of Crystal are you using?
This is for ver 10 developer

1. You need to make sure that you have selected the correct data type when first setting up your parameter.
2. For example, I have my data type set to string, I click on default values and select the table then I select the field. Then I click the double greater than chevrons to move all data from that field to be used as default values.
Next I set up my record selection to reference the field being used.

Hope that helps.
GJ

No comments:

Post a Comment