1215994 - Unable to see all database objects in Crystal Reports

SAP Knowledge Base Article - Public

1215994 - Unable to see all database objects in Crystal Reports

Symptom

  • Unable to see all database objects.
  • Some Tables, Views, Stored Procedures, are missing.
  • When connecting to a database in Crystal Reports, not all Tables, Views, or Stored Procedure, are displayed in the Database Expert.

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. In Crystal Reports, create a new report.
  2. In the Database Expert, connect to a data source that contains a large number of objects. ( Tables, Views, Stored Procedures,... )
  3. Notice it is missing some tables, views, stored procedure,..

Cause

  • 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.
  • 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.

Resolution

  • To modify the number of database objects displayed in Crystal Reports when connecting to a Data Source, increase the value of the registry key: NTablesMax:

    WARNING The following resolution involves editing the Microsoft Windows Registry. Using the MS Registry Editor incorrectly can cause serious problems. Use the MS Windows Registry Editor at your own risk. Refer to the SAP Knowledge Base Article 1323322 for more information. 

    1. In MS 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: 10000, 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 10,000 database objects.

Keywords

TABLE LIMIT NTABLESMAX RETURNED RETURNS BRING BACK RETRIEVE FETCH CONNECT Crystal Reports Connections to database objects Maximum number of database objects , c2013280 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports XI R2 ; SAP Crystal Reports, version for Visual Studio .NET 2005 ; SAP Crystal Reports, version for Visual Studio .NET 2008 ; SAP Crystal Reports, version for Visual Studio .NET 9.1