Symptom

In Crystal Reprots Normally the number of entries in the drop-down list box in the “Select

Expert” window is limited since the database has more values:

Difficulty:

Intermediate – Expert

Solution:

To increase the number of entries in the drop-down list box in the “Select Expert” window,

try the following steps:

1. Close the Crystal Reports XI.
2. On the ‘Start’ menu, click ‘Run’.

3. Type ‘Regedit’ in the ‘Open’ text box, and then click ‘OK’.
4. In the Windows Registry Editor, navigate to the following sub key:

Update the following registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\ DatabaseServer\

Select the string “MaxNBrowseValues”, right click on it and select modify. In the modify

screen, select “Decimal” under the “Base” section and type “5000” in the text box and click

the OK button.

Now, close the registry editor.

Note:

Now we could see all the data in the list.