Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

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

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

jlopeman (IS/IT--Management)
25 Apr 11 12:48
I've been tasked with creating reports off SQL 2005 and 2008 database(s). When creating new reports on these databases, the database expert does not list all of the tables in the database. Since the database is quite large and has many tables, I'm wondering if there is some default setting that Crystal uses to cut off the list of databases available to chose from in the database expert? If there is a setting, where is it? I'd like to be able to see all the tables in the database.

Thanks much.
fisheromacse (IS/IT--Management)
25 Apr 11 14:59
to the best of my knowledge, the table listed are all that the user has permissions to view.   
jlopeman (IS/IT--Management)
25 Apr 11 15:29
That is what I thought, but I'm not seeing all the tables. There are 6,300 tables (no, I didn't design this application/database) and it lists all the tables down to the ones starting with "O" and quits.

I'm thinking its some sort of ODBC issue.
fisheromacse (IS/IT--Management)
25 Apr 11 15:35
yeow!

i am sure i do not have 6300 tables, maybe 500 total and i thought it was overdesigned.  guess i won't complain!  

if i can be nosy, what sort of app/vendor is it??
Helpful Member!  LyleU (Vendor)
26 Apr 11 2:52
Actually, the number of objects (tables, views, sprocs, etc...)is determined by an entry in the Registry. Here is some information, from the Business Objects Knowledgebase, that will get you pointed in the right direction:
_________________________________________________________
KBase Article ID:c2013280

Cause:
The number of database objects returned to CR is determined by the setting in the Windows Registry. The default value for this registry setting is 8,000. You can change this default value by editing the Windows registry setting, NTablesMax.
NTablesMax - specifies the number of database  objects to get a listing of from the database. Once this number is reached the listing of objects in Crystal Reports is stopped. Objects can include tables, views, synonyms and stored procedures.

Solution:
To access the NTablesMax item in the registry:
1. On the Start menu, click Run.
2. Type "Regedit", then click OK. The Registry Editor will appear.
3. Browse to the following folder:

CR XI Release 2

HKEY_CURRENT_USER\Software\Business Objects\Suite 11.5\Crystal Reports\FetchOptions
CR XI (Release 1)

HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\FetchOptions

CR 10

HKEY_CURRENT_USER\Software\Crystal Decisions\10.0\Crystal Reports\FetchOptions
CR 9

HKEY_CURRENT_USER\Software\Crystal Decisions\9.0\Crystal Reports\FetchOptions

CR 8.5

HKEY_CURRENT_USER\Software\Seagate Software\Crystal Reports\FetchOptions
4. In the right-hand window of the Registry Editor, double-click NTablesMax. The 'Edit DWORD Value' dialog box appears.
5. Select Decimal.
6. In the Value Data text box type "10,000". Click OK.
7. Close the Registry Editor and then restart your computer.

The next time you open Crystal Reports, you will be able to see all 10,000 database object
__________________________________________________________

It's not just the number of tables, but the total number of objects. Also, giving your version of Crystal would help narrow down any advice that would be forthcoming.
 

Lyle
----
Research is what I am doing when I don't know what I am doing. - Werner Von Braun

 

jlopeman (IS/IT--Management)
26 Apr 11 12:42
@fisheromasce -- its NextGen EMR application.
fisheromacse (IS/IT--Management)
26 Apr 11 13:32
ah, k.
i had looked at them in the past for EMR for LTC and upon hearing about the tables can add one more reason i am glad we didn't go with them.
jlopeman (IS/IT--Management)
26 Apr 11 15:58
@LyleU -- thanks! Your tip did it. My apologies for not submitting more info (i.e. CR version).
LyleU (Vendor)
26 Apr 11 17:04
You are very welcome.

I think that I will have to post this one as my first FAQ as it does seem to come up from time to time.
 

Lyle
----
Research is what I am doing when I don't know what I am doing. - Werner Von Braun

 

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

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