Crystal Report v 11.0 - Dynamic Selection Parameters

Yahoo Archive
1
Hi Patty,

I've tried this and it works. From the SAP Forum:

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 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
Create a registry key HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects
\Suite 11.0\Crystal Reports\DatabaseOptions\LOV.
NOTE
Alternatively, you can create the registry key HKEY_CURRENT_USER
\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions
\LOV and that key will override the settings of the HKEY_LOCAL_MACHINE
\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions
\LOV key.

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.

After making changes to the registry, restart the affected service or
application as required.
Crystal Reports XI Release 2
Create a registry key HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects
\Suite 11.5\Crystal Reports\DatabaseOptions\LOV.
NOTE
Alternatively, you can create the registry key HKEY_CURRENT_USER
\SOFTWARE\Business Objects\Suite 11.5\Crystal Reports\DatabaseOptions
\LOV and that key will override the settings of the HKEY_LOCAL_MACHINE
\SOFTWARE\Business Objects\Suite 11.5\Crystal Reports\DatabaseOptions
\LOV key.

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.

After making changes to the registry, restart the affected service or
application as required.
Additional Information
This document is not applicable for reports based on Universes. These
registry keys do not affect the List of Values returned when a report
is based on a Universe. See knowledge base article 200603.
To modify the maximum number of values available in a dynamic
parameter list on UNIX, refer to knowledge base article c2018918.


--- In vantage@yahoogroups.com, "bpbuechler" <pbuechler@...> wrote:
>
> Is there a solution to the issue of max 1,000 records on the drop
down
> list when you use Dynamic Selection?
>
> TIA
> Patty Buechler
> UV Color
>
2
Is there a solution to the issue of max 1,000 records on the drop down
list when you use Dynamic Selection?

TIA
Patty Buechler
UV Color