You can create a report program to extract and print fields on the database in the format you specify. In this example, a report is printed showing the customer details for each region.
Sales Order Example Reports SALESORD TOTALS 14 Feb 1993 18:10 Page 10
Summary report printing sub-totals for one or more categories
Region Running Customer Order Order
Code Count name Number Value
SEE 53 Amps W T 5 3.12
54 Bellerose Capt D P 23 226.55
55 Friodé N 64 727.94
56 Perry G 33 72.65
57 Weller C 39 75.25
58 Kennedy R P 43 1094.75
59 Keown T 44 625.57
60 Richmond P 45 2054.34
61 Cuthburt I 47 100.00
62 The Hair Company 57 204.72
STATISTICS FOR South East England
Total number of orders: 10
Average order value is: 518.49
Total value of orders is: 5184.89
|