Datasheet

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.
8.
Drill down on a country by double-clicking the report.
Tip:
When drill down is available, your cursor turns into a magnifying glass.
Crystal Reports retrieves the appropriate Detail records as you need them.
For instance, if you drill down on Australia, Crystal Reports quickly retrieves the seven records that
make up the group.
By hiding the Details section of this report, you've created a summary report that's easy for users to
navigate. Each user can first locate the Country with which he or she is concerned, and can then drill
down to retrieve valuable details.
Moreover, by enabling the Perform Grouping on Server option, you've ensured that the initial processing
is completed on the database server. Consequently, only the necessary records are transferred to the
report.
For more information on server-side processing, see Server-side processing.
6.6.3 Using SQL Expressions for groups, sorts, and totals
For reports using Perform Grouping on Server, avoid sorting, grouping, or totaling on a formula field
(whether Crystal or Basic syntax). Instead, replace the original formula field with an equivalent SQL
Expression Field, and then sort, group, or total on the SQL Expression field. This will greatly improve
the chances of the processing being done on the server.
For details on when else to use SQL Expressions, see Using SQL expressions where appropriate.
6.6.4 Using SQL Expressions for Case Logic
If your database supports Case Logic, and your report needs to summarize an If-Then-Else formula
calculation, replace the formula with an SQL Expression field. In such cases, SQL Expression fields
enable Crystal Reports to perform the report's grouping on the server.
For instance, suppose that you're reporting off of an MS SQL Server 7 database, which supports Case
Logic. You need to include an If-Then-Else calculation in your report, and you need to summarize that
2011-05-16127
Designing Optimized Web Reports