Skip to Content

LOV Limit in crystal

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Nov 09, 2012 at 04:54 PM

    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


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2012 at 04:58 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.