Parameter List Limit
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.
Sastry Duvvuri replied
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.