Creating a Grand Total

Objective

After completing this lesson, you will be able to Display a grand total in a report.

Grand Totals

The grand total displays at the end of the report in the Report Footer section. If you have a multiple page report, be sure to go to the last page to see the grand total.

The options available depend on the data type on which you are basing the calculation.

Some examples are:

  • Number fields: Sum, average, count, minimum, maximum and various other summary functions are available.
  • String fields: Count, minimum, and maximum are some of the summary functions that are available.

When you select the Grand Total field in the report, you see its full name in the Status bar. The Grand Total field automatically lines up with and attaches to the same guideline as the data field it was based on.

Log in to track your progress & complete quizzes