Chapter 9: Presenting Data with Access Reports .........................................................................
321
Columnar reports
Columnar reports generally display one or more records per page, but they do so vertically.
Columnar reports display data very much as a data-entry form does, but they’re used strictly for
viewing data and not for entering data. Figure 9.2 shows part of a columnar report (rptProd-
ucts) in Print Preview.FIGURE 9.2A columnar report showing report controls distributed throughout the entire page
Another type of columnar report displays one main record per page (like a business form) but can
show many records within embedded subforms. An invoice is a typical example. This type of
report can have sections that display only one record and at the same time have sections that dis-
play multiple records from the many side of a one-to-many relationship — and even include totals.Figure 9.3 shows an invoice report (rptInvoice) from the Collectible Mini Cars database system
in Report view.In Figure 9.3, the information in the top portion of the report is on the “main” part of the report,
whereas the product details near the bottom of the figure are contained in a subreport embedded
within the main report.