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