1270986 - How to modify the maximum number of values available in a dynamic parameter list for a 64 bit terminal?

SAP Knowledge Base Article - Public

1270986 - How to modify the maximum number of values available in a dynamic parameter list for a 64 bit terminal?

Symptom

How to modify the maximum number of values available in a dynamic parameter list for a 64 bit terminal?

 

Environment

  • Windows Server 2008 - 64 bit
  • Windows Server 2003 - 64 bit
  • Crystal Reports XI
  • Crystal Reports XI Release 2 (R2)
  • Crystal Reports 2008
  • Crystal Reports for Visual Studio 2010
  • Crystal Reports 2011

Reproducing the Issue

If you have a cascading LOV (for example Country > Region > City), the lowest level (in this case City) will only display a maximum of 1000 values. This means that the higher-level prompts may display far fewer values than you expect. The LOV provides the data for the dynamic parameter list.

Cause

For performance reasons, in Crystal Reports XI the maximum number of values that are returned for a list of values (LOV) is set to 1000

Resolution

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

CAUTION

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. For information on how to edit the registry key, view the 'Changing Keys and Values' online Help topic in the Registry Editor (Regedit.exe).
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.

 

Crystal Reports XI Release 1
  1. Create a registry key HKEY_LOCAL_MACHINE\Wow6432Node\Business Objects\Suite 11.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. NOTE: The value 0 (Unlimited) will not work with BusinessObjects Enterprise XI or Crystal Reports Server XI, you must specify another value.

NOTE

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

 

  1.  After making changes to the registry, restart the affected service or application as required.
Crystal Reports XI Release 2
  1. Create a registry key HKEY_LOCAL_MACHINE\Wow6432Node\Business Objects\Suite 11.5\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. 

NOTE

The value 0 (Unlimited) will not work with BusinessObjects Enterprise XI or Crystal Reports Server XI, you must specify another value.
  1. After making changes to the registry, restart the affected service or application as required.
Crystal Reports 2008 Release
  1. Create a registry key HKEY_LOCAL_MACHINE\Wow6432Node\Business Objects\Suite 12.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.

Crystal Reports 2011 Release

  1. Create a registry key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\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.

Crystal Reports for Visual Studio 2010

  1. Create a registry key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Crystal Reports for .NET Framework 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.

See Also

  • For performance reasons Crystal Reports limits the maximum number of values returned to a list of values
    • For more details see note number 1218588

Keywords

Maximum List of Values, 64 bit, Cascading Prompt, Crystal Reports, , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , BI-BIP-ADM , BI Servers, security & CrystalReports viewing in BI platform , How To

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports XI R2