cancel
Showing results for 
Search instead for 
Did you mean: 

Limits of Crystal Reports when accessing SQL databases

0 Kudos

I seemed to have reached a limit of some kind in the database that my vendors software is using. When I open stored procedures in management studio i see all stored procedures. When I open stored procedures in the database expert it only goes as far as the ones that start with the letter S and I know there are many more after those.

Accepted Solutions (0)

Answers (2)

Answers (2)

vitaly_izmaylov
Employee
Employee
0 Kudos
DellSC
Active Contributor
0 Kudos

Crystal has a default limit of, I think, 256 items in the list. However, there is a registry setting that can be configured to get around that.

You don't mention which version of Crystal you're using. For Crystal 2011, 2013, and 2016, you'll use this one:

32-bit Windows: HKEY_CURRENT_USER\Software\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\FetchOptions

64-bit Windows: HKEY_CURRENT_USER\Software\WOW6432Node\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\FetchOptions

Edit the NTablesMax setting - change it to "Decimal" and either increase it or set it to 0 to show all entries (may be slow).

-Dell