There is a limit to Crystal Dynamic parameters. The limit is 1000 items, which may not be enough if you need all of your inventory items in a report selection criteria field.
Here’s how to change the limit:
Important: As with any changes to the system registry – do so at your own risk and have a backup. Incorrect changes may render your computer or applications inoperable.
Crystal Reports 2011
1. Create a registry key HKEY_HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV.
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.
3. After making changes to the registry, restart the affected service or application as required.
NOTE: the registry key on 64 bit Operating Systems is:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV