Yes their is a limit to how many values can be populated in the Dynamic List,you will need to change the registery settings for LOV list of values

 

This issues is been resolved in Crystal Reports 2008.....

 

 

How can you modify the maximum number of values available in a dynamic parameter list?

Resolution

To increase the maximum number of values available in a dynamic parameter list, you will add a registry key.

====================

WARNING:

The following resolution involves editing the registry. Using the Registry Editor incorrectly can cause serious problems that may require you to reinstall the Microsoft Windows operating system. Use the Registry Editor at your own risk.

HELP:

For information on how to edit the registry key, view the 'Changing Keys and Values' online Help topic in the Registry Editor (Regedit.exe).

RECOMMENDATION:

It is strongly recommended that you make a backup copy of the registry files (System.dat and User.dat on Win9x computers) before you edit the registry.

====================

1. Create a registry key HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV.

====================

NOTE:

Alternatively, you can create the registry key HKEY_CURRENT_USER\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV and that key will override the settings of the HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV key.

====================

2. Add a string value "MaxRowsetRecords" and set the value to the maximum number of values that you desire for your report. For example, a value of 2000 will return up to 2000 values in the lowest level of a cascading parameter. NOTE: The value 0 (Unlimited) will not work with BusinessObjects Enterprise XI or Crystal Reports Server XI, you must specify another value.

====================

WARNING:

The higher the number of values is, the longer it will take the 'Enter Values' dialog box to populate with values.

====================

NOTE:

After making changes to the registry, restart the affected service or application as required.

====================

More Information:

To modify the maximum number of values available in a dynamic parameter list on UNIX, refer to knowledge base article c2018918 on our support site:

http://support.businessobjects.com/search/