jlopeman
IS-IT--Management
- Apr 25, 2011
- 35
CR XI
XP
SQL Server 2005
MS Server 2008
I write a lot of reports using cascading, dynamic parameters. I ran into an issue where Crystal Reports was limiting the number of results returned on the lowest level parameter. I found the fix for the issue as listed below. However, I was wondering if the same fix can be done for crystal report viewer. Or, does it matter? Our application calls .rpt files and the end-user interacts with the report using CR viewer.
Solution ID
9759
Summary
How can you increase the number of values in a dynamic parameter list?
Symptoms
Details SYNOPSIS
=====================================
For performance reasons, in Crystal Reports XI the maximum number of values that are returned for each level of a list of values is set to 1000. The list of values provides the data for the dynamic parameter list.
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.
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.
====================
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.
XP
SQL Server 2005
MS Server 2008
I write a lot of reports using cascading, dynamic parameters. I ran into an issue where Crystal Reports was limiting the number of results returned on the lowest level parameter. I found the fix for the issue as listed below. However, I was wondering if the same fix can be done for crystal report viewer. Or, does it matter? Our application calls .rpt files and the end-user interacts with the report using CR viewer.
Solution ID
9759
Summary
How can you increase the number of values in a dynamic parameter list?
Symptoms
Details SYNOPSIS
=====================================
For performance reasons, in Crystal Reports XI the maximum number of values that are returned for each level of a list of values is set to 1000. The list of values provides the data for the dynamic parameter list.
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.
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.
====================
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.