Skip to Content
0

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

Feb 21 at 08:54 PM

16

avatar image
Former Member

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Gabriel Schroedter Feb 21 at 09:10 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Vitaly Izmaylov
Feb 21 at 09:01 PM
0

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
Share
10 |10000 characters needed characters left characters exceeded