Print Page | Close Window

Parameter Question

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=573
Printed Date: 04 May 2025 at 6:08am


Topic: Parameter Question
Posted By: slotmachine
Subject: Parameter Question
Date Posted: 24 Apr 2007 at 7:59am
I have created a report with a parameter of VENDOR. My fields Vendor_Name has over 200 vendor names. When I select the Vendor parameter it isn't coming over with all of my vendors to select. Is there limit in the parameter and is there a way to increase the amount of data coming from a field to over to the parameter? Thank you for any help on this issue. Crystal 9.0


Replies:
Posted By: BrianBischof
Date Posted: 24 Apr 2007 at 10:58am
There was just a post on this a few days ago. I don't know about CR 9, but there are options that let you set how much data to load from the table. Look under report options. Also, I think that previous post mentioned a registry setting you can change to load more items as well. Do a search to track down that post and it should be pretty helpful.

-------------
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>

Posted By: anil
Date Posted: 24 Apr 2007 at 1:29pm
if nothing works then i guess you can add another command using the same query but with only the column you want to be displayed in drop down. associate this  field to your main query for final filteration.

-------------
anil

Posted By: slotmachine
Date Posted: 01 May 2007 at 12:15pm

For future reference :

    Regedit/Seagate Software / Crystal Reports / Database Server / MAxNBrowseValues  and NRecordsThreshold


Print Page | Close Window