Browse data does not list all values available in database export

When browsing the field values to create a Select Expert, Groups or using the Browse Data function in the Field Explorer only limited data is displayed. This is due to the fact that only a sample of the first 500 values are parsed by Crystal Reports. This limitation exist in both Crystal Reports 8.5 and XI versions.

Article Number: 49574

Products:

Crystal_Reports

This may be resolved by either of the following two solutions:

Ensure that report Select Distinct record values only

Go to File, Report Options
Mark the checkbox for the setting Select Distinct Data for Browsing
Click OK

Change the 500 limit in the Registry Key

In Windows, click on Start, Run and enter Regedit
Go to HKEY_CURRENT_USER,Software, Business Objects, Suite 11.0, Crystal Reports, DatabaseServer, MaxNBrowseValues* (Crystal Reports XI R1) - OR -
Go to HKEY_CURRENT_USER, Software, Seagate Software, Crystal Reports, Database Server, MaxNBrowseValues * (Crystal Reports 8.5)
Right click this key and select Modify (Base=Decimal), and change the value from the default of 500 to a higher value

* If MaxNBrowseValues does not exist then create it (right click DatabaseServer, New, DWORD Value, enter MaxNBrowseValues).

Blackbaud Community

Connect and collaborate with fellow Blackbaud users.

Chat with Support

Chat with our experienced staff to receive help right away.

Connect

The Blackbaud team is online and ready to connect with you!