Increase Limit of Data Expert for Tables, Views and Stored Procs in Crystal Reports

May 13, 2025

Increase Limit of Data Expert for Tables, Views and Stored Procs in Crystal Reports

I’ve been recently doing some consulting for a school using a piece of software (a SIS called Synergetic) that uses Crystal Reports and switching to a new workstation has meant there were a few things I needed to get set up again. One of the frustrations I quickly found was that the Data Expert view wasn’t showing all of the Tables, Views and Stored Procedures I was expecting. While there isn’t a hard-coded limit, I remembered that there was a registry key you need to change to get the default view to increase.

Close Crystal reports and then load up Regedit and navigate to the following registry path

HKEY_CURRENT_USER\Software\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\FetchOptions

Now find NTablesMax DWORD and adjust it to decimal and enter another value larger than the default 8000 (I’ve set mine to 32000)

Once you’ve set that new value, start Crystal Reports again and you should be able to see more values be returned now.

This is always something good to do whenever setting up your workstation with Crystal Reports, this works for 64-bit versions of SAP Crystal Reports 2016, 2013, 2008 and XI.

Hope that helps.

Using WireGuard on Windows with no local administrator rights

I’ve recently been helping a non-profit uplift their security – we’ve put in a UniFi Gateway along with cleaning up their 365 tenancy and endpoint management. As part of this, we’ve implemented a WireGuard VPN back to their NAS as well as remove local admin rights from end users. Unfortunately, WireGuard by default requires local […]

Use Microsoft Excel to split words into cells for easier data manipulation

A client was recently part of an expo and used the opportunity to collect subscribers for their mailing list. Unfortunately the data input method wasn’t designed with their back end database in mind which has a potential customer’s first name and last name separated into different fields. Luckily the data was clean enough that we […]

Exchange Management with AD Users when using RSAT for Windows 7

One of the little things with the have annoyed me since I’ve started using the RSAT tools in Windows is the fact that there is no easy way to manage Exchange. Sure I can install the Exchange Management Pack and use that, but like most admin’s AD Users and Computers is open just about all […]

A Windows System Admin's Blog