LOV Limit in crystal

[rakesh_m2]

Hi All,

I am new to crystal development.  I developed a new report with a BEx Query with some filters on query.  But I am getting only 200 values in the LOV of parameter.  I see some documentation to change the registry key in

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

from 200 to 5000.  I changed that, but still it did not take effect on my report.  I restarted my crystal, but still it did not work.

Please help me in fixing this issue.

Thanks,

Rakesh

[abhilash_kumar · Accepted solution]

Hi Rakesh,

That's not the correct registry path. If you're on a 32-bit machine then browse to:

HKEY\LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\SAP\BWQueryReportWrapper\MaxPickListSize

If you're on a 64-bit machine, browse to:

HKEY\LOCAL_MACHINE\SOFTWARE\Wow6432Node\Business Objects\Suite 12.0\SAP\BWQueryReportWrapper\MaxPickListSize

Change the value from 200 to 5000 or more.

Hope this helps!

- Abhilash

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[Former Member]

Hi Rakesh,

The default number of values in a list is limited to 1000 records.

This is, however, controlled by a registry key. To increase this limit, here's what you need to do:

Open regedit and browse to:

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

Create a new key (or folder) 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 20000.

Do this on the HKEY_LOCAL _MACHINE hive as well.

and Adding to more

In Crystal Reports Designer the list of values is limited and you can set the limit using a registry values.

Look in the area of :

HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\....\SAP\BWQueryReportWrapper

Where I entered "..." that is where you see a version number.

When you publish / save the report to the server the list of values will be retrieved live.

Hope this information will help you...

--Naga.