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.