Wednesday, February 6, 2013

Crystal Reports - Parameter Dynamics List does not show all values

This is a bug with Crystal itself.

To rectify this, and have Crystal display all parameter values,


  1. Click Start, Run 
    1. If run is not enabled, right click on start>properties>start menu>customize>scroll to the bottom>tick Run Command
  2. Type in "regedit"
  3. Expand HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\
    1. The "Suite 11.0" folder will be different depending on your version of Crystal
  4. Right click on Crystal Reports> New>Key> Type in "DatabaseOptions"
  5. Right click on DatabaseOptions> New>Key> Type in "LOV"
  6. Select LOV
  7. On the right hand side of the window in the white area, right click>New>String Value>Type in "MaxRowsetRecords"
  8. Double-click MaxRowsetRecords
  9. Type in -1 (-1 displays all available records)
  10. Restart Crystal
The final key that you should have added is: 
(For V11)
HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV\MaxRowsetRecords (String) Set to -1

or
(For V12)
HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV\MaxRowsetRecords (String) Set to -1

If this does not work, ensure that you have entered the names EXACT with no spaces.
This will work. If it does not, you have a typo somewhere.

No comments:

Post a Comment