Database Reference
In-Depth Information
1.
In Layout mode, choose Layouts
→
New Layout/Report
.
The New Layout/Report dialog box appears.
2.
In the “Show records from” pop-up menu, make sure the Lease Agreement table
is selected. In the Layout Name box, type
Lease Agreement Report
. Click the
Computer icon and then choose Report from the layout type list in the lower half
of the screen. Click Continue
.
After you click Continue, the “Include Subtotals and Grand Totals” panel appears.
3.
If they're not already selected, choose “Include subtotals” and “Include grand
totals,” and then click Next
.
After you click Next, the Specify Fields panel appears.
4.
Move the First Name, Last Name, Rental Fee, and Lease Duration fields to the
“Fields shown on layout/report” box and then click Next
.
This should be familiar territory by now. Remember that you can use the arrow to the
left of each field to move them up and down in the list on the right. After you click
Next, the “Organize Records by Category” panel appears.
5.
Move the Lease Duration field into the Report categories list and then click Next
.
The sample report icon changes as you move fields into the Report categories list.
After you click Next, the Sort Records panel appears.
6.
Move the Last Name and First Name fields into the Sort order list and then click
Next
.
Lease Duration is already in the list, because that's how the report will categorize the
list. But you want records with the same Lease Duration value to be sorted alphabetic-
ally by Last Name and then by First Name. After you click Next, the Specify Sub-
totals panel appears (
Figure 4-24
).
7.
From the Subtotal Placement pop-up menu, choose “Above record group” and
then click Specify under “Summary field.”
The Specify Field window appears.
8.
Click Add
.
The “Options for Summary Field” window appears (
Figure 4-25
). You'll create a spe-
cial field that counts the records in each category. The field will appear above the re-
cord group it summarizes because of the choice you made in step 7.
