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:
- From the machine where Crystal Designer resides, click Start, Run, and enter regedt32 in the Open field and click OK (requires administrator access rights).
- 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.
- Double-click the key named NTablesMax and select Decimal as the Base. Replace the default of 8000 with a higher number like 20000.
- Click OK and close the Registry Editor.
- 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:
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:
Want to learn more about how having an experienced Sage partner can help your business?
