Crystal Reports Parameter values

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

Topic: Parameter values

Author	Message
myschif Newbie Joined: 15 Apr 2008 Online Status: Offline Posts: 7	Topic: Parameter values Posted: 15 Apr 2008 at 1:26pm
	Greetings, I am passing SQL parameters to crystal XI to enable the users to choose the proper parameter(s). However, not all of the available choices are listed in the parameter selection window? The list ends before all available choices are displayed. Thank you in advance for your any assistance.
	IP Logged

BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 15 Apr 2008 at 2:37pm
	Do you have a lot of records in the table? By default, CR only reads 1,000 records before creating the list of values to display. You have to add a registry entry to override the default behavior. HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV If you are using R2, then change 11.0 to 11.5. Add a string called MaxRowsetRecords and set a new maximium number of records. Making it 0 gives you unlimited records. I cover this in the book on page 204 (in addition to numerous other tips and tricks for using parameters). You can find out more about my books at Amazon.com or reading the Crystal Reports eBooks online.
	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

myschif Newbie Joined: 15 Apr 2008 Online Status: Offline Posts: 7	Posted: 15 Apr 2008 at 4:00pm
	Hello Brian, Thank you for the response. There are thousands of records. I have gone into the registry and found the following: HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.5\Crystal Reports\DatabaseOptions\ However there was no HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV The LOV is missing? How would I proceed?
	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.