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

sort the records within each region in alphabetic order by Customer Name.
Many of your reports will use some type of sorting. Depending on the report,
you will sort the records in a list or sort in conjunction with grouping. See
Sorting single and multiple fields , and Sorting records within groups .
Summaries, subtotals, and grand totals
Many reports use some sort of totaling. For example, in a North American
sales report grouped by state, you might want to calculate the total dollar
amount sold in each state. You do this by creating a subtotal on the sales
field. Summaries are also used at the group level, allowing you to calculate
averages, counts, and other group (aggregate) values. For example, in a
sales report you may want to calculate an average of sales per state (average
summary on the sales field) and calculate the number of products sold in
the state (distinct count of the product name field).
Using the drill-down option on summarized data
You can drill down on your data, to show the data behind individual groups,
using the Drill-down cursor. See
Sorting, Grouping, and Totaling .
Drill-down cursor
Crystal Reports allows you to drill down on group or summary information
in the Preview tab in both the Standard and the Group Tree (See
Standard
view and Group Tree ). When you position the cursor over any summary
value that you can drill down on, the program displays a Drill-down cursor.
Tip:
Group headers appear on the Drill-down tab just as they do in the main report
itself.
If you then double-click, the program reveals the details behind that specific
summary value. For example, if the Drill-down cursor becomes active over
the city summary, you can double-click to see the details behind that
summary.
• If you have only a single summary, you can look at the summary or at
the data from the individual records that are summarized.
132 Crystal Reports 2008 SP3 User's Guide
Introduction to Reporting 6
Creating a new report