List Values in Dynamic Parameter Limitation

[codrutza]

CRXI on SQL Server Management Studio Express
I'm trying to make a report with dynamic parameter. For some reason it picks only a part from the Customers for the list in the parameter (the parameter list shows for our db, only from the customers which start with A to customers which start with J). I did the same parameter on Customers from Xtreme db and works fine, it shows all the customers. Is it a number limitation for the values of a dynamic prompt? In our db there are much more Customers than in Xtreme.
Thanks

 

[RTag]

Create a registry key:HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV

add a string key "MaxRowsetRecord" and set the value to the MAX number of Customers you expect.

You may need to reboot in order this value to take effect.

http://www.R-Tag.com

Viewer, scheduler and report manager for Crystal reports and SSRS.
Send your report everywhere.

 

[lbass]

There is a limit of 1000 values to the LOV, so if your first parameter in combination with the second level parameter results in more than 1000 values, the number of values returned by the first parameter will be reduced to keep the total values within limits.

Changing the registry values will address this, but you should be very careful whenever working with a registry.

You should also consider your approach--over 1000 values is an awful lot for a user to scroll through. Maybe there is another way to approach this.

-LB