Parameter List Limit

[Former Member]

Hi All,

I have created a dynamic parameter list of values for cities. It created a list with 5 batches. The 5th batch of values stops at cities starting with the letter 'P'.

How do I increase the limit of my list of values to include all of my cities from A-Z? I am running Crystal Reports 2008.

Thank you in advance.

[Former Member · Accepted solution]

Hi Antoine Saikaley

This can be resolved by editing the registery. Also this is applicable for CR2008. :

Symptom

Only 1000 LOV values can be viewed at a time.

Cause

Default number set for LOV in Crystal Reports XI R2

Resolution

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.

Thanks,

Sastry