Skip to end of metadata
Go to start of metadata

The following article has been transferred to https://help.synergetic.net.au/s/article/Unable-to-see-all-database-objects-in-Crystal-Reports

Sometimes in Crystal Reports you'll find that you cannot see all tables, views or stored procedures available to you. 

This may be permissions related or if you have a large number of custom user objects such as Views and Stored Procedures you the below fix may assist in allowing you to view all of these objects.

The issue usually presents itself when creating a new report and inside the Database Expert you'll notice missing tables, views, stored procedures.


One approach is to reduce the number of items shown.

You can do this by going to Database > Database Expert and right clicking on the datasource and selecting Options.

From there you can de/select stored procedures or other objects as required.


The number of database objects returned in Crystal Reports is determined by the setting in the Windows Registry: NTablesMax.  The default value for this registry setting is 8,000.

The following resolution involves editing the Microsoft Windows Registry. Using the Registry Editor incorrectly can cause serious problems. Use the MS Windows Registry Editor at your own risk.

  1. In Windows on the Start menu, click Run.
  2. Type "Regedit", then click OK.
  3. In the Microsoft Registry Editor will appear, browse to the following folder:
      • Crystal Reports 2008:
        • HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports\FetchOptions
      • Crystal Reports 2011, 2013, 2016:
        • HKEY_CURRENT_USER\Software\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\FetchOptions
  4. In the right-hand window of the Microsoft Registry Editor, double-click NTablesMax. The 'Edit DWORD Value' dialog box appears.
  5. Select Decimal.
  6. In the Value Data text box type a greater value like: 20000, then click OK.
  7. Close the Microsoft Registry Editor,
  8. Reopen Crystal Reports.

The next time you open Crystal Reports, you will be able to see all 20,000 database objects.

https://apps.support.sap.com/sap/support/knowledge/public/en/1215994