A Windows System Admin's Blog

Covering Server Administration, Endpoint Management, Scripting and Network Management

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.

Leave a Reply

More Posts

Publish Remote Apps and Desktop Session at the same time

I was recently building a PoC Lab environment for a client where I only had a couple of virtual machines to play with to build a Remote Desktop Services environment to host a line of business application. I needed to be able to publish the application as a Remote App as well as have a […]

Remote Desktop is Blocked in Windows Firewall even though Group Policy Setting is set to allow

So I’m going through and trying to automate a lot of things in our environment (one thing you should always try and do as a SysAdmin is to automate repetitive tasks) and to help me achieve this I’m using Group Policy, step one is enable Remote Desktop to all of our Servers automatically. Created the Group […]

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 […]