Skip to Content
avatar image
Former Member

Certain lists on CR have been deleted--how can I resolve?

So when you prompt for new parameter values on one of our reports the drop down lists are only giving us to the letter 'L'...it should go as fas 'Z'...please advise--thank you!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Feb 21 at 09:10 PM

    Ryan is running Crystal Reports 2016. What operating system are you running it on?

    What data source are you using for reference to make the list? What confirmation do you have that the data source to make the list has not changed?

    To help us see what you're seeing, can you share a (possibly redacted) screenshot of the list with the scroll down showing you're at the bottom. I'm certain you're not overlooking something obvious like that but presenting that screenshot will keep people from asking.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 21 at 09:01 PM

    There is a default limit of 1000 values for CR parameters.

    to increase the limit follow:

    https://apps.support.sap.com/sap/support/knowledge/public/en/1218588

    To increase the maximum number of values for a List of Values (LOV), set the registry key: MaxRowsetRecords, to a value greater than 1,000:

    WARNING The following resolution involves editing the Microsoft Registry. Using the Microsoft Registry Editor incorrectly can cause serious problems. Use the Microsoft Registry Editor at your own risk. For more information see the SAP Knowledge Base Article 1323322

    1. Open the Microsoft Registry Editor (regedit)
    2. In the Microsoft Registry Editor, navigate to the path corresponding to the version of the product used:
      • Crystal Reports 2008:
        • 32bit version of MS Windows:
          HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV
        • 64bit version of MS Windows:
          HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV
      • Crystal Reports 2011, 2013, 2016:
        • 32bit version of MS Windows:
          HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV
        • 64bit version of MS Windows:
          HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\DatabaseOptions\LOV
    Add comment
    10|10000 characters needed characters exceeded