Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Parameter List Limit

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.


Hi Antoine Saikaley

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


Only 1000 LOV values can be viewed at a time.


Default number set for LOV in Crystal Reports XI R2


Crystal Reports XI Release 2

Create a registry key HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.5\Crystal Reports\DatabaseOptions\LOV.


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.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question