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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Parameters - Number of default values limit

Seagate Documents

Report Parameters - Number of default values limit

by  FoxG  Posted    (Edited  )
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.

Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top