Depending on the number of events that Crystal is querying, you might get an error on maximum processing time or maximum record limit. To set your server to process a higher number or an unlimited number of records you must reconfigure the Crystal Page Server. This can be done by using either the Central Configuration Manager or the Crystal Web Page.
Click Start > All Programs > BusinessObjects 11 > Crystal Reports Server > Central Configuration Manager.
Right-click Crystal Reports Page Server and select Stop.
Right-click Crystal Reports Page Server and select properties.
In the Command field under the Properties tab, at the end of the command line add:
maxDBResultRecords <value greater than 20000 or 0 to disable the default limit>
Restart Crystal Page Server.
Click Start > All Programs > BusinessObjects 11 > Crystal Reports Server > .Net Administration Launchpad. Alternatively, open a Web browser and provide the following URL:
http://<hostname_or_IP_of_web_server>:<port number_for_webserver_port>/businessobjects/enterprise115/WebTools/adminlaunch
Click Central Management Console.
The System Name should be your host computer name. Authentication Type should be Enterprise. If not, select Enterprise.
Provide your user name, password and click Log On. Click Servers.
Click <server name>.pageserver.
Under Database Records to Read When previewing or Refreshing a report, click Unlimited records. Click Apply.
A prompt to restart the page server will display, click OK.
You might be prompted for a logon name and password to access the operating system service manager.
To improve performance, the Top 10 reports included in the Sentinel Core Solution Pack query summary tables instead of the events table. The summary tables contain counts over time for combinations of fields in the event data. This provides a much smaller data set for certain types of queries and results in much faster queries and report run time.
The Aggregation service is responsible for populating the summary tables with summarizations of all of the events in the events table. The Aggregation service will only generate summarized data for summaries that are active. The following summaries are required by the Top 10 reports and are enabled by default:
EventDestSummary
EventSevSummary
EventSrcSummary
Summaries can be activated or inactivated using the Report Data Configuration window under the Admin tab of Sentinel Control Center.
The Aggregation service also depends on the EventFileRedirectService component in DAS Binary to feed it the event data that it will summarize. Therefore, this component must be enabled in order for the Aggregation service to run properly. This component is enabled or disabled by modifying the "status" attribute of the EventFileRedirectService component in the das_binary.xml file to “on” or “off”. By default, this component is “on”.
NOTE:For information about EventFileRedirectService and the three aggregation summaries, see Report Data Configuration
in Admin in the Sentinel 6.1 User Guide.
NOTE:Reports that query a large date range might take sometime to run. They can be scheduled instead of running interactively. For information about scheduling Crystal Reports, go to Crystal Reports Server XI R2 documentation and click the CRYSTAL REPORTS SERVER.pdf.
The above mentioned URL was current at the time of publication of the document.
The Crystal Reports Developer can be used to create or modify Crystal reports. For custom developed reports, the following is recommended:
If the reports can utilize pre-defined aggregate tables, select the aggregate table that result in the processing of the least amount of data.
Try to push most of the data processing to the database engine.
To reduce processing overhead in Crystal Server, minimize the amount of data to retrieve to the Crystal Server.
Always write reports against the database views provided by Novell instead of writing reports against the base tables.