Crystal Reports Parameter Limits

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Parameter Limits

Author	Message
WhenF1CantHelp Newbie Joined: 03 Aug 2007 Location: United States Online Status: Offline Posts: 10	Topic: Parameter Limits Posted: 04 Oct 2007 at 10:58am
	What are the limits to parameters? I created a parameter to select cities, my database contains around 13,000 cities. Crystal responds by saying the "Query is too complex". I can probably do with out most of the cities but would still need around 2000 for the parameter to be of any use.
	IP Logged

BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 04 Oct 2007 at 11:01pm
	I don't think this has anything to do with the number of records being returned. Have you run the query independently on your database to see if it works or to see it's response time? I would see if you can simplify the query. Also, I wonder if you're using MS Access as your database? This is an Access error.
	Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
	IP Logged

IdoMillet Groupie Joined: 26 Oct 2007 Location: United States Online Status: Offline Posts: 99	Posted: 26 Oct 2007 at 5:00pm
	To change the limit, you need to edit the registry. See:KBase Article ID:c2017238 http://support.businessobjects.com/library/kbase/articles/c2017238.asp - Ido
	view, e-mail, export, burst, distribute, and schedule Crystal Reports. www.MilletSoftware.com
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.