cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

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.

vitaly_izmaylov
Employee
Employee
0 Kudos

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