Command Objects in Dynamic Cascading Prompts

This is the solution. I had a link to BizObjects website, but since SAP
took it over, the support site is horrible now.

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.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bpbuechler
Sent: Wednesday, November 05, 2008 8:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Command Objects in Dynamic Cascading Prompts

Yes, we use Command Objects as part of Dynamic Cascading Report Prompts.


However, there is a limitation which we have found no solution to.
It will only list the first 1,000 records. If there are more, they do
not display/prompt. Which if you are working with the Part or PartWhse
table...you are pretty much out of luck.

Has anyone else run into this and found a solution?

Thanks
Patty Buechler
UV Color

--- In vantage@yahoogroups.com, "kfmonico" <kfmonico@...> wrote:
>
> Has anyone used Command Objects as part of Dynamic Cascading
Prompts in
> Crystal 11.5? This is the only way I have found so that you can
have a
> default selection when you are using Dynamic Prompts. I have read
> about it but I cannot find a format that will work. Appreicate any
> help.
>



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
Has anyone used Command Objects as part of Dynamic Cascading Prompts in
Crystal 11.5? This is the only way I have found so that you can have a
default selection when you are using Dynamic Prompts. I have read
about it but I cannot find a format that will work. Appreicate any
help.
Yes, we use Command Objects as part of Dynamic Cascading Report
Prompts.

However, there is a limitation which we have found no solution to.
It will only list the first 1,000 records. If there are more, they
do not display/prompt. Which if you are working with the Part or
PartWhse table...you are pretty much out of luck.

Has anyone else run into this and found a solution?

Thanks
Patty Buechler
UV Color

--- In vantage@yahoogroups.com, "kfmonico" <kfmonico@...> wrote:
>
> Has anyone used Command Objects as part of Dynamic Cascading
Prompts in
> Crystal 11.5? This is the only way I have found so that you can
have a
> default selection when you are using Dynamic Prompts. I have read
> about it but I cannot find a format that will work. Appreicate any
> help.
>