on 10-29-2019 1:10 AM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.