INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • 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.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Seagate Documents

Report Parameters - Number of default values limit by FoxG
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

My Archive

Resources

Close Box

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:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close