You have already learned all the language syntax necessary to:
Sort information
Relate information from different tables
Derive new data with calculations and aggregate options
The reports you have seen so far display data from a single table (the Customer table) and demonstrate one or two reporting features. Real world reports, however, frequently do a little bit of everything as they strive to organize lots of information and calculate useful summary information.
For example, suppose the All Around Sports accounting department needs to analyze delinquent accounts. To do their jobs, the accountants need information on customers, orders, and inventory. To get all the data they need, the report requires information from four tables: the Customer, Order, OrderLine, and Item tables. The rest of this section builds a report that gathers and organizes information from these four tables and performs some summary calculations on the data.
Sort information
