RKL eSolutions Blog Trends and Insights

Crystal Reports Doesn’t Display All Objects in the Database

If you use Crystal Reports with an ERP System database, chances are you have encountered this issue. There is a registry setting in Crystal Reports that restricts the number of objects that are available to add to a report to 8000. This can be problematic in today’s ERP systems, which can easily exceed that number of objects, especially when Tables, Views, and Stored Procedures are included. This issue can be solved with a simple registry change and restarting Crystal Reports.
** NOTE: Please make a backup of the registry before making any changes**

Here are the steps:

  1. From the machine where Crystal Designer resides, click Start, Run, and enter regedt32 in the Open field and click OK (requires administrator access rights).
  2. Expand HKEY_CURRENT_USER\Software\Business Objects\Suite 11.5\Crystal Reports\FetchOptions

NOTE: This path may vary slightly, depending on your version of Crystal. You could also Search through the registry for FetchOptions, which is the same in all the versions I’ve worked with. Keep in mind, you may have multiple versions of Crystal Reports on the same machine.

 

image001

  1. Double-click the key named NTablesMax and select Decimal as the Base. Replace the default of 8000 with a higher number like 20000.  

image003  image005

  1. Click OK and close the Registry Editor.
  2. Re-launch Crystal Reports and you should now see all the objects that are in your data source.

For example, let’s open Crystal Reports 2013, launch the Database Expert and use an ODBC data source and connect into a Sage 500 SQL Database. With the default 8000 objects in Crystal in the registry, my table list stops at tsoChngOrder:

Crystal Reports Database Expert Screen

After the change to the NTablesMax option in the registry to 20000, I’m now able to see all the tables in my database from the Database Expert in Crystal Reports:

Database Expert Screen Crystal Reports

 Want to learn more about how having an experienced Sage partner can help your business?

Get In Touch >>

Tony Baron

Written by Tony Baron

Tony Baron is a seasoned Customer Support Engineer with over 17 years of experience in supporting accounting software packages. His technical expertise spans Microsoft SQL Server and various programming languages. Tony's proactive approach to technical problem solving highlights his commitment to customer satisfaction and product advocacy.