Datasheet

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.
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).
2011-05-16126
Designing Optimized Web Reports