Default values for a parameter field 1

[APS]

1. I selected a field from my database as my browse field when setting up a parameter, but all the values in the field are not showing up. Can anyone tell why this is happening and if I can fix it any other way other then manualing adding them.

2. Can I set it so when someone prints a report and types a value that is not in the default list that it adds it to the list so the next time it is printed it is in the list.

Thanks
[sig][/sig]

 

[MalcolmW]

1) The defaults are set at the time the report parameter is created, and it is not updated when the field values change.

2) You would have to write your own code for that - it might be easier just to write code to do a select distinct from that field, and populate the drop down list with that. That way, typos wouldn't get added to drop down list.
[sig][/sig]

 

[kenhamady]

APS,

Let me answer the first question.

Crystal reads the first 500 records to create the "browse" list that you see. It will eliminate any duplicates in this list, so you may only see a handful of values, depending on what occurs in the first 500 records.

In version 8 there is an option that forces Crystal to list the first 500 unique values (or go to the end of the file). This is called "Select Distinct Data for Browsing" and is usually defaulted to "ON".

As to the second question, while the user can add there own values to the selection, they can't add to the list.
[sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]

 

[APS]

Thanks

That helps alot!! [sig][/sig]