Skip to Content
author's profile photo Former Member
Former Member

CR10 ODBC connection - not all tables show

When I connect to the Data Source, not all of the tables are available. When I connect to the ODBC in MS Access, I can see all of them just fine. I installed the service packs and hot fixes available. I also changed the default registry key to 8000.

A possible problem I see is on the screen which prompts the username and password to connect, the Service Name is not shown as an option on the screen as it is in Version 8.5 and XI

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2008 at 03:31 PM

    Are you using Oracle? If so you likely have to increase the NTablesMax key value in the registry. Medium to large Oracle deployments can easily generate tens of thousands of data objects. The total number of tables and other objects exposed by Oracle may exceed the permitted total in Crystal Reports.

    You can fix this by increasing the NTables Max registry value. Try increasing it to 15000 or even 50000 or 80000 if needed. Here are some different registry paths to the NTablesMax key for three different versions of Crystal Reports (with CR10 in the middle).

    PS. Before you try this, if you are using Oracle you can try the native driver and you will probably see all of the tables with this driver. If you are using another database try an OLE DB connection such as OLE DB for ODBC and you likely will see all of the tables with this connection as well.

    XIR2

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

    CR10

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

    CR9

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2008 at 03:25 PM

    What version of Access are you using?

    If it's newer and you're using CR10 I'd suspect you may have to move up a few versions (upgrade) to XI-R2 or R3 (CR2008)....

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.