Tip: missing objects in Crystal Database Expert

If you ever find yourself attempting to modify a Crystal Report and you notice that some tables are missing from the 'Data' tab of the Database Expert tool within Crystal that shows you the tables that are available to be added to the report, it is most likely due to the NTablesMax default registry value being too low.  I actually just encountered this.  I was trying to add a tso table to a report, but the list of available tables displayed was ending in the tpo range.  What the heck?  Where are the rest of the tables?  After googling the situation, it turns out that this was a result of my NTablesMax default registry value being too low.  It was set to 8000 on my system.  Unless that value is set based on the amount of system RAM present during CR installation (which I doubt), then that is probably the same value you'll find in your registry as well.  It may be the case that the only reason I was being affected by this default value of 8000 is because I have a couple 3rd-party add-ons installed which have increased the number of tables in my MAS DB.  In fact, given that I've not seen any discussion of this before, I suspect that may be the case.  So, this tip might only be relevant to those of you with 3rd-party add-ons installed that have added a significant number of items to your DB.

In any event, if this helps someone, here is the simple fix that I used.

HKCU\Software\Crystal Decisions\10.0\Crystal Reports 10 for Sage\FetchOptions\

Change the NTablesMax DWORD value from 8000 to 32000.