Crystal Reports provides many tools for analyzing information that has been drawn from a database. A good example is the ability to summarize data. To demonstrate this feature, a summary of the account balances will be added to the Customer report.
To add a summary:
1. Click .
The Insert Summary dialog box appears:
2. Select Customer.Balance as the field to summarize, select Sum as the calculation to make to the summary, and place the summary in the Customer.State group. After making those choices, click OK. The sum of all outstanding accounts for each state appears at the end of each group:
3. Click once more.
The Insert Summary dialog box appears:
4. Choose Customer.Balance once again as the field to summarize. Select Sum as the calculation to make. Select Grand Total (Report Footer) as the location for the summary. Click OK. A grand total of all outstanding accounts appears at the end of the report.
.
