User`s guide

6.6.1 Performing grouping on server
If you're reporting in real-time off live data over the Web, reduce the amount of data transferred from
the database server by using the Perform Grouping on Server option. With this option, much data
processing is off-loaded to the database server and only a subset of data is read initially. Detail data is
returned from the database only when you drill down in a report.
Note:
Server-side processing works only for sorted and grouped reports that are based on SQL data sources.
6.6.1.1 To enable server-side processing
1.
On the File menu, click Report Options.
2.
Select Perform Grouping on Server on the Report Options dialog box.
This check box is inactive if Use Indexes or Server for Speed is not selected.
Tip:
When Use Indexes or Server for Speed is selected, you can quickly enable Perform Grouping On
Server from the Database menu.
3.
Click OK.
6.6.2 Benefits of grouping on server—an example
The following example describes a typical reporting scenario wherein grouping on server can significantly
reduce the amount of unnecessary data transferred from the database server.
6.6.2.1 To decrease data transfer by grouping on server
1.
Open the sample report Group.rpt.
Look in the bottom right corner of the Crystal Reports window and notice that 269 records are
returned for this report.
2012-03-14126
Designing Optimized Web Reports