Contact US

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.

Students Click Here

Business Objects: Crystal Reports 2 Data Access FAQ

Viewing Objects in Crystal

I can't see all of the tables in my database when trying to create a report. by LyleU
Posted: 17 Aug 11

The number of objects (tables, views, sprocs, etc...)is determined by an entry in the Registry. (Of course, you must have the proper access to all of the tables in your database.) Here is some information, from the Business Objects Knowledgebase:
KBase Article ID:c2013280

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.

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 10,000 database objects


Back to Business Objects: Crystal Reports 2 Data Access FAQ Index
Back to Business Objects: Crystal Reports 2 Data Access Forum

My Archive

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