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