SAP Knowledge Base Article - Public

1215994 - Unable to see all the Tables, Views or Stored Procedures in Crystal Reports when connecting to database containing a large number of objects

Symptom

  • Unable to see all the database objects.
  • Some Tables, Views, Stored Procedures, are missing.
  • Not all Tables, Views or Stored Procdure are listed when connecting to a database containing large number of objects.
  • 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 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

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

  • Not all the tables, views, synonyms, or stored procedures are displayed in Crystal Reports when:
    • The database user does not have rights to see the tables in the database; or
    • Crystal Reports Data Explorer options filters are limiting the tables to display; or
    • Database contains a large number of objects, and Crystal Reports by default is limited to show the first 8,000 objects only.
                
  • If the user have rights to see the tables, and there is no Data Explorer options set to filters the tables, then it is the default number of objects limiting what is displayed:
    • Crystal Reports limit the number of objects to display to ensure the product show a list of tables, views, synonyms and stored procedure in a timely manner.
    • The number of database objects returned in Crystal Reports is determined by the setting in the MS Windows Registry: NTablesMax
    • The default value is: 8,000

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. Close Crystal Reports. (If it is running.)
           
    2. Start the Microsoft Registry Editor. ( Regedit )
                   
    3. In the Microsoft Registry Editor, navigate to the folder:

      For MS Windows (64bit):
      HKEY_CURRENT_USER\Software\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\FetchOptions 

      For MS Windows (32bit):
      HKEY_CURRENT_USER\Software\Wow6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\FetchOptions
              
    4. In the right-hand window of the Microsoft Registry Editor, double-click: NTablesMax
               
    5. In the 'Edit DWORD Value' dialog box, select: Decimal
             
    6. In the Value Data text box, type a value like: 10000, then click: OK     
      ( Value: 0 means no limit. )
               
    7. Close the Microsoft Registry Editor.
             

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

See Also

  • To verify the Database Options set in Crystal Reports to filter the objects displayed, see the SAP Knowledge Base Article: 2111282 

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 Business View Manager , Problem

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020 ; 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