Default value list in parameter field problem

[ryangus]

What is the maximum number of records that can be used in a default value list for a parameter field? It seems to be cutting off after about 500, both in the available values list and the default values list.

 

[dgillz]

Actually this is a restriction in the registry.
Go to start, run regedit, go to HKEY_CURRENT_USER, Software, Seagate software, Database Server, and edit the key MaxNBrowseValues.

By default this is set to 500, which is where you are running into the wall. Change this to some large number such as 10,000 and then when you browse field data to come up with a list of default valued you will see up to 10,000 distinct values.

The largest I have ever personally seen in this regard was about 7200 default values. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[chelseatech]

Even with a longer list, the default values are frozen at development time.

I'm about to release a utility that will update a folder of reports and load the latest values into each parameter. Have a look at my web site in the next few weeks and look for cViewPICK.
Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm