Displaying A Crystal Report With Thousands of Dynamic Parameter Values

It is not uncommon to have a developer ask us how the Logicity Crystal Reports viewer and scheduler can handle a dynamic parameter list with a lot of options. Like a lot. Like how about well over 1,000? And the answer is, after a little tweaking of the registry, just fine thank you! If you have a report with a parameter with more options than you even want to count, read on to learn how to get this accomplished.

 Out of the box, Logicity by default will only show 500 options on a dynamic parameter drop-down.  However, by making a few registry edits, you can adjust this amount as needed.  Follow along to learn which registry entries you need to add or change depending on the version of Logicity that you are currently running.

Logicity v1.7

For users running the latest version of Logicity, version 1.7, follow these steps:

Logicity Registry Update

• HKEY_LOCAL_MACHINE\SOFTWARE\SAP Business Objects\Crystal Reports for .NET Framework 4.0\Crystal Reports\DatabaseOptions\
• Add DatabaseOptions under Crystal Reports.
• Add LOV under DatabaseOptions.
• Add Stringkey MaxRowsetRecords under LOV
• Set value to maximum number of records to read (for Talon, use 20000).

Note: If you are on a 64-bit PC this key is located at:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP Business Objects\Crystal Reports for .NET Framework 4.0\Crystal Reports\DatabaseOptions\

Crystal Reports Development Registry Update

• HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV
• Add LOV under DatabaseOptions.
• Add Stringkey MaxRowsetRecords under LOV
• Set value to maximum number of records to read (for Talon, use 20000).

Logicity v1.6

For users running an older version of Logicity, version 1.6, follow these steps:

Logicity Registry Update

• HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV
• Add DatabaseOptions under Crystal Reports.
• *Add LOV under DatabaseOptions.
• Add Stringkey MaxRowsetRecords under LOV
• Set value to maximum number of records to read (for Talon, use 20000).

Crystal Reports Development Registry Update

• HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV
• Add LOV under DatabaseOptions.
• Add Stringkey MaxRowsetRecords under LOV
• Set value to maximum number of records to read (for Talon, use 20000).