Crystal 8.5 - Select Expert

Posted on 2006-11-01
Medium Priority
Last Modified: 2009-08-20
When using Select Expert in Crystal 8.5 I will choose a table/field, select "is one of" and use the drop down list to select the individual cases/occurrences/types that I want.  The list runs from A - G and stops... I know the list goes through at least S.  Why can't I see all the data?


Question by:frankrentef
  • 4
  • 3

Author Comment

ID: 17850215
Note:  I am talking about an email list with over 1200 users.
LVL 28

Expert Comment

ID: 17850238
Crystal has a limit to the first 500 unique values.  This is for performance reasons.
To change it, you need to edit a value in the registry.
Drill down in the registry on HKEY_CURRENT_USER\Software\Crystal Decisions\8.5\Crystal Reports\DatabaseServer (this might be slightly different as I don't have 8.5 installed to confirm)
Look for "MaxNBrowseValues" and Double Click on it.
Change the radio button to Decimal, then increase the 500 value to whatever you need it to be.

Author Comment

ID: 17850787
I'm finding a Crystal Decisions directory then

Crystal Decisions/2.0/bin/ *.dll

I don't find a .dll named MaxNBrowseValues....42 .dlls in all in the directory.


Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

LVL 28

Expert Comment

ID: 17850909
Start menu, Run.
Type in Regedit.
Look for the path there

Author Comment

ID: 17851038
I have a Crystal Decisions/9.0/Crystal Reports Designer Component/DatabaseServer/default

Name = default
type = reg_sz
data=value not set

if I click on modify I get "value data" and a blank
LVL 28

Assisted Solution

bdreed35 earned 500 total points
ID: 17852294
Is there anything else under DatabaseServer besides default?

Author Comment

ID: 17852334
Database Options
New Object
Query Engine
Saved Data

All will "default"
LVL 26

Accepted Solution

Kurt Reinhardt earned 500 total points
ID: 17852485
If you really have 8.5, then the Registry key to change is:

HKEY_CURRENT_USER\Software\Seagate Software\Cyrstal Reports\Database Server

As Brian said, change the default value for MaxNBrowseValues to something greater than 500 (such as 1500, to accommodate your specific needs)


Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Free Data Recovery software is an advanced solution from Kernel Tools to recover data and files such as documents, emails, database, media and pictures, etc. It supports recovery from physical & logical drive after a hard disk crash, accidental/inte…
Watch the video to know how one can repair corrupt Exchange OST file effortlessly and convert OST emails to MS Outlook PST file format by using Kernel for OST to PST converter tool. It can convert OST to MSG, MBOX, EML to access them. It can migrate…

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question