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).

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!

We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.

We’re sorry to hear that. Please tell us why.

I don't like how this works.

The answer is confusing.

The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.

Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.

Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.

Thanks for letting us know. We'll work on updating the search engine to return more relevant results.

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!