Maximum limit for Crystal Report parameter choice box?

[scb1776]

Crystal Report version 11.0.0.1994

My report uses a dynamic parameter and has a scrollable choice box that displays the values from the database. It was working great during development, however during testing it was attached to a database with a large number of values in that table and now it does not seem to show the ones at hte bottom of the list. Is there a limit to the number of records that will be displayed? If so, is there any way around this limit?

 

[samiam07]

I believe the limit is 1000.
There is a registry hack that will let you change that limit, but I can't think of it off the top of my head.

Try a search on Crystal Reports pick list limit

 

[scb1776]

Thanks

 

[MJRBIM]

WARNING : You will also hit performance issues if you are sending really large param values (eg. 5,000+) to a dynamic parameter.

The report load into the viewer will start to crawl - or error out.

Senior Business Intelligence Consultant
Toronto, Canada

SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) | Crystal ( 7 -> 2008) design | WebI design | Best practices for Java / .Net / Web Services