BROWSING DATA

[Herriot]

When Browsing data is there a limit to the amount of data that can be browsed?

Example:
Our serial numbers go up to and pass 29### but browsing the data only showed numbers up to 28### - numbers higher did not show. Even using the SELECT EXPERT and using the "is one of" criteria only showed those serial number 28### and below.

TIA

 

[dgillz]

First off, neither the select expert nor a record selection formula restricts the data you can see by browsing.

Most likely the problem is your settings. By default you can only see the first 500 records when browsing. To change this on a report by report basis, go to File, Report options, and uncheck the "Select distinct data for browsing". This must be done to all reports that were written under the default, which has theis option checked.

To do this as a report default uncheck the same option under the file menu, options, database tab. This way future reports will not have this problem.

Please let me know if you have any questions. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[kenhamady]

Changing to distinct will examine the first 500 different values in the table you are browsing, but will still limit to 500. To change the limit itself you have to chang a registry setting for Crystal Reports.

For v6-8 the registry entries are at:
HKEY_CURRENT_USER\Software\Seagate Software

look for "MaxNBrowseValues" in the DatabaseServer Folder.

You should always be very careful when making changes in the registry. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com

 

[Herriot]

Thanks to both of you. Dgillz's solution worked a treat and Kens will when I get the courage up to change the registry.

Regards

Herriot