Skip to main content

Crystal report parameter list doesn't display all of the records in the list

Updated over a month ago

Crystal reports has a default limit of 1000 on the number of rows displayed by a parameter list. This is controlled by a registry key. The resolution involves editing the registry and this should only be performed by someone with an appropriate level of knowledge.
To resolve this, please follow these steps on the server that runs the crystal report:

  1. Click Windows Start.

  2. Type regedit.exe.

  3. Click regedit to open it.

  4. Find the registry key: 

    32 bit: HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\[your Crystal version]\Crystal ReportsDatabase Options\LOV   64 bit: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Business Objects\[your Crystal version]\Crystal ReportsDatabase Options\LOV

  5. If the key LOV does not exist, add it.

  6. Add a new string called MaxRowsetRecords.

  7. Modify the string value to 10000 (must be higher than the number of rows in your list).

  8. Restart the application pool serving the crystal reports.

Did this answer your question?