This script uses data from two different fields named TOTAL DUE, one in the MEMBERS table (containing membership fee data), and the other from the RESERVATIONS table (containing reservation price data).
The output from this script might look as follows:
|
Last Name |
Total Due |
Total Due > 100 |
Count of RESERVATIONS with TOTAL DUE > 1500 |
|
Broadrick |
$100.00 |
NO |
1 |
|
Gauthier |
$140.00 |
YES |
1 |
|
Goetz |
$70.00 |
NO |
1 |
|
Jackson |
$35.00 |
NO |
0 |
|
Kowalski |
$70.00 |
NO |
1 |
|
Manzi |
$100.00 |
NO |
1 |
|
McKenna |
$85.00 |
NO |
1 |
|
Schwartz |
$70.00 |
NO |
1 |
|
Steinberg |
$120.00 |
YES |
2 |
|
Sullivan |
$70.00 |
NO |
1 |
|
Young |
$105.00 |
YES |
1 |
Number of MEMBERS with TOTAL DUE > 100 : 3
In the output above, the count of totals for each member are displayed as list items in the Report Detail Area while the count total is displayed at the bottom of the output in the Report Summary Area. This is accomplished by placing the count of total on the Record object in the procedure layout and the count total on the Form object.