INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
Are you a
Computer / IT professional?
Join Tek-Tips now!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- One-Click Access To Your
Favorite Forums
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
Feedback
"...Want to thank those people who have made this forum such a valuable place to visit each day..."
Geography
Where in the world do Tek-Tips members come from?
|
Business Objects: Crystal Reports 4 Other topics FAQ
|
Seagate Documents
|
Report Parameters - Number of default values limit
Posted: 8 Jun 01
|
Parameter Fields - Default Values.
How to populate the default values for a parameter with more database field records.
The number of records browsed, and the number of records used to populate default values for a parameter are determined by two items in the Windows registry:
· Browse Timeout - specifies how long (in seconds) Crystal Reports browses the data in your database
· MaxNBrowseValues - specifies how many records Crystal Reports browses in your database
Once the conditions have been satisfied for one of these items, Crystal
Reports stops browsing the database.
If you are using a 16-bit version of Crystal then you need to edit your crw.ini file as detailed at the end of this paper.
If you are using 32-bit Crystal Report Designer you can use this document or alternatively access the original document at:
http://support.seagatesoftware.com/library/kbase/articles/c2006602.asp
32 - bit SCR Users
WARNING============
The Windows registry stores configuration data that is crucial to the
operation of the Windows operating system. Only people experienced with
using the Windows registry should undertake the following steps. Do NOT
modify the registry if any of these steps are confusing to you.
=====================
To access the BrowseTimeOut and MaxNBrowseValues items in the registry:
1. Close Crystal Reports (SCR). This ensures the following changes are
saved.
2. In Windows 9x/NT, go to 'Start' then click 'Run'.
3. Type 'Regedit' (no quotes), then click 'OK'. This opens the Registry
Editor.
4. Drill down as shown below.
· If you have 32-bit version 5 of SCR, drill-down to following registry subkey:
HKEY_CURRENT_USER\Software\Crystal Software\Crystal Reports\DatabaseServer
· If you have a 32-bit version 6, 7, or 8 of SCR, drill-down to following registry
subkey:
HKEY_CURRENT_USER\Software\Seagate Software\Crystal Reports\
DatabaseServer
5. To change how long SCR browses the data in your database:
· Double-click the BrowseTimeout item. This opens the 'Edit DWORD Value'
dialog box.
· In the 'Base' section, select 'Decimal'
· In the 'Value Data' box, type in the maximum number of seconds you SCR to
spend reading your database before stopping and displaying all unique
values it found. Entering zero disables the timeout option.
· Click OK to save the change.
6. To change how many records SCR browses in your database:
· Double-click the MaxNBrowseValues item. This opens the 'Edit DWORD
Value' dialog box.
· In the 'Base' section, select 'Decimal'.
· In the Value Data box, type in the maximum number of records you want SCR
to read before stopping and displaying all unique values it found.
· Click OK to save the change.
7. On the 'Registry' menu click 'Exit'
8. Restart Windows.
The next time you re-open Crystal Reports, these changes will be in effect.
16-bit SCR Users
(if there is by any chance anyone out there using an old version of SCR - at home perhaps!!)
In order to set the database browsing so that it will bring back all of the records -
Close SCR
In the CRW.INI file the following default values are set:
set MaxNBrowseValues=100
set BrowseTimeout=5
These values say:
search for 5 seconds or get max 100 values from the database, whichever comes first.
Changing them both to 0 will result in all of the data displaying as there
now is no limit on time or value to get all values.
Other values can be used, the first limit reached stops the browse.
The next time you re-open Crystal Reports, these changes will be in effect.
|
Back to Business Objects: Crystal Reports 4 Other topics FAQ Index
Back to Business Objects: Crystal Reports 4 Other topics Forum
|
|
 |
|
Join Tek-Tips® Today!
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
Talk To Other Members- Notification Of Responses To Questions
- Favorite Forums One Click Access
- Keyword Search Of All Posts, And More...
Register now while it's still free!
Already a member? Close this window and log in.
Join Us Close
