Refresh parameter drop down list

[PeterConnick]

I am using Crystal Reports 10
Oracle DB

I have a parameter called city and I want to prompt the user to select a city from a drop down list.

Table Name Address
Field Name City

{ADDRESS.CITY}

When I originally built the parameter, I selected table ADDRESS and the field City and moved all the values into the default values field.

However since that time more cities have been added to ADDRESS table. Is there a way to refresh the prompt drop down list?

 

[lbass]

Assuming you have already gone to database->verify databsase, I think you then have to remove the current values and then reselect the field and add the values again. I think XI is the first version with dynamic parameters.

-LB

 

[PeterConnick]

I was afraid that was going to be the answer. Thanks for the response.