incomplete list in Set Default Values for a parameter

[wrbodine]

Hi,

I'm creating a parameter to use with the Select Expert, and when I click on "Set Default Values" and choose the table and field that are needed, an incomplete list comes back (missing only a very small percentage of the strings). By playing around I noticed that when I change the ORDER BY clause in the Sql Query for the report that the values sometimes change in this list also (even drastically, like only bringing back names alphabetically through the letter B). Is this some kind of bug in Crystal? Any hints for how to get the entire list of values from the table to show up??

Thanks,
Ray

 

[bjrollet]

I don't think this is a bug. I think this is a sampling issue. It think it would take too many resources to pull in the complete table. All I do is type in the value I want (a valid value) and the selection wroks just fine.

 

[Roadkill150]

Hello,
Crystal only pulls the first 500 records or 8 seconds worth of data from the database when you browse fields or create parameter pick lists. You can increase this by registry changes..
Here is the info from Crystal on how to do this:

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.

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 (CR). 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 version 5 of CR, drill-down to following registry subkey:

HKEY_CURRENT_USER\Software\Crystal Software\Crystal Reports\DatabaseServer

· If you have version 6, 7, or 8 of CR, drill-down to following registry subkey:

HKEY_CURRENT_USER\Software\Seagate Software\Crystal Reports\ DatabaseServer

5. To change how long CR 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 CR 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 CR 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 CR 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.

Seagate Certified RCAD Specialist.
-Bruce Thuel-Chassaigne
roadkill150@hotmail.com

 

[wrbodine]

Thanks Bruce!

Hey, if I make these changes in the registry on one machine that has Crystal & then run the report, do these changes get saved with the report? How does that work? Will that report be set from then on, or if another developer opens and runs it would the incomplete list come back?

Thanks again,
Ray

btw - we use Crystal 7.0