Missing Tables

[BradW]

Good evening, I have a SQL Server database where I'm using views, there are approximately 1000 table views (800 or so are code tables) and in Crystal Reports XI, the list of views stops after about 900, the last 100 or so do not show up on the list. I've heard of this happening before, but I've never seen it. This same database has worked well on several other machines, with Crystal starting at version 7 and up through 2008, so I don't know why all the views are not showing on this particular set of machines. Any ideas?

Thanks in advance for all help!

 

[LyleU]

Here is a post that I made in the Great Plains forum some time ago. You will have to do some research regarding your database and the total number of database objects, but it does sound like the same issue.

LyleU

*************************

Try this solution from the Business Objects Knowledgebase.

KBase Article ID:c2013280

Cause:
The number of database objects returned to CR is determined by the setting in the Windows Registry. The default value for this registry setting is 8,000. You can change this default value by editing the Windows registry setting, NTablesMax.
NTablesMax - specifies the number of database objects to get a listing of from the database. Once this number is reached the listing of objects in Crystal Reports is stopped. Objects can include tables, views, synonyms and stored procedures.

Solution:
To access the NTablesMax item in the registry:
1. On the Start menu, click Run.
2. Type "Regedit", then click OK. The Registry Editor will appear.
3. Browse to the following folder:

CR XI Release 2

HKEY_CURRENT_USER\Software\Business Objects\Suite 11.5\Crystal Reports\FetchOptions
CR XI (Release 1)

HKEY_CURRENT_USER\Software\Business Objects\Suite 11.0\Crystal Reports\FetchOptions

CR 10

HKEY_CURRENT_USER\Software\Crystal Decisions\10.0\Crystal Reports\FetchOptions
CR 9

HKEY_CURRENT_USER\Software\Crystal Decisions\9.0\Crystal Reports\FetchOptions

CR 8.5

HKEY_CURRENT_USER\Software\Seagate Software\Crystal Reports\FetchOptions
4. In the right-hand window of the Registry Editor, double-click NTablesMax. The 'Edit DWORD Value' dialog box appears.
5. Select Decimal.
6. In the Value Data text box type "10,000". Click OK.
7. Close the Registry Editor and then restart your computer.

The next time you open Crystal Reports, you will be able to see all 10,000 database object