To increase the maximum number of values for a dynamic parameter list of values, set the registry key: MaxRowsetRecords, to a value greater than 1,000
1) Open the Microsoft Registry Editor, and navigate to the path corresponding to the version of Crystal Reports used:Crystal Reports 2008: - HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOVCrystal Reports 2011: - HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOVCrystal Reports 2013: - HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOVCrystal Reports 2016: - HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOVCrystal Reports for Visual Studio 2010: - HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\DatabaseOptions\LOV
NOTES:
- Add the key: LOV, if it is not present.
- For 64 bit version of Microsoft Windows, the registry path will be slightly different, it will start with:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\...
2) Add the String value: MaxRowsetRecords
IMPORTANT NOTES: - The higher the number of values set, the longer it will take to see the dynamic parameter prompt screen. In brief, it impacts the performance.
- The value 0 (Unlimited) will not work with BusinessObjects Enterprise XI or Crystal Reports Server XI, you must specify another value.
3) Close Crystal Reports Designer and then make the changes to the registry, reopen Crystal Reports, or restart the Crystal Reports services for the BusinessObjects platforms.
NOTE: For workstations without Crystal Reports installed, you will need to create the above registry key under the 'Crystal Reports for .NET Framework' registry folder, which represents the Crystal run-time that the Sage workstation uses.
Comments