Crystal Repors 2008

[#1]

I am using Dynamic Parameters in Crystal 2008 with about 4000 choices. There appears to be a limit to how many are displayed. How can I change this.

[Former Member]

Hi,

Adding to Abhilash's point, You can increase the LOV Batch Size too: By default 200 is the Batch size.

There is a registry key to control batch size in Crystal Reports 2008:

Go to the following key:

HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports\ReportView

and modify decimal value for "PromptingLOVBatchSize".

Cheers,

Kiran

[abhilash_kumar]

Hi,

It is a registry key that controls this and the limit is set to 1000 values by default.

Normally, on client machines, registry keys need to be put under the HKEY_CURRENT_USER folder, so go to 'regedit' and browse to this location:

HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions

Create a new key called 'LOV' here and then on the right-hand side create a new string value called 'MaxRowsetRecords' with a value higher than 1000, perhaps around 10000 as a start.

Hope this helps!

-Abhilash

[Former Member]

Hi,

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. 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.

3. After making changes to the registry, restart the affected service or application as required.

Thank you,

Saritha