HP Intelligent Management Center Standard Software Platform - Manual (Page 187)

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.
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.
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.
Note:
You'll see this number only if you have the Status Bar option selected on
the View menu.
2. On the Report menu, click Section Expert to access the Section Expert.
3. In the Sections list, select Details.
4. On the Common tab, select Hide (Drill-Down OK). This hides the report's
Details section, so that only group header displays in the report. (In this
case, the report is grouped by Country.)
5. Click OK in the Section Expert. The Details records will disappear from
the report.
6. Press F5 to refresh the report data (or click the Refresh button on the
toolbar).
Notice that 269 records are still returned for the report, even though the
Detail records are hidden from view.
7. On the Database menu, click Perform Grouping on Server.
Now notice that only 71 records are returned for the report. The grouping
(by Country) has been performed on the database server, and fewer
records have been transferred to the report.
Crystal Reports 2008 SP3 User's Guide 187
8 Designing Optimized Web Reports
Improving grouping, sorting, and totaling