Summarize Data

You can either use the Total Wizard or enter summarized totals manually.

The Total Wizard

Select the Report band and click Insert Totals on the Insert menu.

Select the data fields to summarize.

Note: If you need to change the summary options from Sum to any other you need to do that manually.

See next section.

Summarize data manually

Select the field and go to the property panels summary options.

Click on  .

Bound field to summarize

Select the bound field to summarize on.

Define the summary function

You can choose a summary function like Sum, max, Min, Average, etc.

Define the summary running option

None:  does not summarize.

Page: summarizes totals for each page.

Group: summarizes totals for each Report group.

Report: summarizes totals for the whole Report.

Format the summarized field

Select a format for the summarized function.

Note: you can also use the Quick Format option on the Format menu

Note: you can also access each summary function value directly in the property box.

 

Movies

Watch Movies

Related

The Visual Report Designer

Design a Report

Report Bands and Sections

Report Wizard

Label Wizard

Work with Fields

Format Fields

Field Properties

Work with Styles

Report Groups

Summarize Data

Calculated Fields

Data Sources

Unbound Sub Reports

Bound Sub Reports

Report Scripting

Page Setup

Preview and Print

Save the Report