Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Maximum limit for Crystal Report parameter choice box?

Status
Not open for further replies.

scb1776

Programmer
Dec 29, 2006
31
US
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?
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top