Skip to main content

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

Crystal Reports has a default limit of 1,000 rows in a parameter list. This is controlled by a registry key. Only someone with the appropriate level of knowledge should edit the registry. 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?