Database Reference
In-Depth Information
11.
Click the Count Leases field to select it and then click OK. Leave the “Grand
total placement” pop-up menu set to “End of report,” and then click Add Grand
Total. Make sure the Lease Agreement::Count Leases field appears in the Grand
Totals list at the bottom of the window. Finally, click Next
.
Summary fields are smart enough to display different data depending on the layout
part they're placed in. So you can use the same summary field in a Subsummary part
and a Grand Total part, and it will display appropriate data in each part. This version
of the Count Leases field will appear at the end of the report and will give you a grand
total count of all the records you're viewing. After you click Next, the “Header and
Footer Information” window appears.
Figure 4-25. You'd see a nearly identical window if you used the Manage Database win-
dow to create a summary field. Summary fields do just what their name implies: They sum-
marize groups of data. You can apply one of several mathematical operations to the fields,
including Totals, Averages, and Counts. You can count any field, but you can't apply math
to text fields. So if you're trying to select a field, but it's grayed out, check the operation
you're trying to perform. It may not be the right option for the field you want to summarize
(or the field's definition may be set to the wrong type).
12.
From the Header's “Top right” pop-up menu, choose Layout Name. From the
Footer's “Bottom right” pop-up menu, choose Current Date. Then click Next
.
The “Create a Script for this Report” window appears.
Click the “Create a script” option, and
Lease Agreement Report
appears in the “Script
name” box. Select the “Run script automatically” option and then click Finish.
