Mastering Business Analysis with Crystal Reports 9 (Wordware Applications Library)

The most common calculations you'll use within your reports are totals. Totals are the sum of all values within a field.

Crystal Reports uses three types of totals. These totals are as follows:

• Subtotals: These are partial totals that summarize the data within a group.

• Grand Totals: These are summaries of all the values within a field for an entire report. Grand total values always display within the Report Footer (located on the very last page of your report).

• Running Totals: These totals display on a record-by-record basis. For example, if you have three records with values of 2, 3, and 4, the running total for each of these three records would be 2, 5, and 9.

  In other words, the first value is 2 because no other value is added, the second value is 5 because the 2 and 3 are added together, and the third value is 9 because the 2, 3, and 4 are added together.

There's good news: You don't have to be a mathematical whiz to include calculations within your reports. Crystal Reports will do the dirty work for you.