Skip to Content

Crystal Reports 2013 - nTablesMax at 20,000 - Still Can't See All Objects on Windows 2012

Even with nTablesMax set at 20,000 or 30,000, I cannot see all DB objects in my SQL Server 2012 DB.

Here's what is different - I am accessing a desktop on Windows Server 2012, R2.

When another user with the same permissions brings up CR 2013, they can see all objects. I cannot.

So it sounds like a Windows desktop on Windows Server is not set up with enough resources, or something....

Anyone have ideas or suggestions? Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 30 at 06:55 PM

    Does another user brings up CR 2013 on the same machine or on different machine?

    Have you tested both DB Users on the same machine?

    have you changed the nTablesMax for HKeyLocalMachine or HKey_CurrentUser? If there are same keys in both locations then CR takes value from HKey_CurrentUser

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 30 at 10:53 PM

    All of that info is loaded into active memory space meaning if you have a lot of applications open you won't see as many.

    Close all applications and try again.

    And why do you need to see that many tables?

    If you need that many I suggest using a stored procedure and do all of the data collection server side.

    Or add filtering so you don't need that many.

    Add comment
    10|10000 characters needed characters exceeded