Issue
- Running an I/NET Seven report and only seeing the first 500 people or doors in a system.
- Keyword search: Crash when an attempt to open, Crystal Reports, and failure.
Product Line
TAC INET
Environment
I/NET system and desire to run reports over a lot of data
Cause
The Crystal Reports that I/NET is using has a default value of 500 objects to be listed in a report. If you require more objects to be listed in a report, this requires a windows registry change to do this.
Resolution
Note in the attached document the registry location may change slightly based on the version of I/NET and SevenReports installed version.
If unsure or the locations cannot be found search for the following registry keys:
- BrowseTimeout - This entry controls how long, in seconds, the Info Report Designer will browse for records.
- MaxNBrowseValues - This entry controls how many unique records the Info Report Designer will browse before stopping and displaying the records found.
For the Release 2.40a and above running the NON_RDC release
HKEY_CURRENT_USER\Software\Business object\Suite11.0\Crystal Reports Designer\
For the Release 2.41 and above running RDC version:
HKEY_CURRENT_USER\Software\Business object\Suite11.0\Crystal Reports Designer Component\
In the Crystal Report terminology, an object could be people or doors, in which case make the registry change based upon the largest number you have. For example, if a site has 5000 people and 500 doors, set the registry to accommodate 5000.
The steps required to make these changes are in the Crystal Report Tech support paper linked to this article.
