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

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 .
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 .
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.
188 Crystal Reports 2008 SP3 User's Guide
Designing Optimized Web Reports 8
Improving grouping, sorting, and totaling