Columnar reports generally display one or more records per page, but do so vertically. Columnar reports display data very much as a data-entry form does but are used strictly for viewing data and not for entering data. Figure 37-2 shows part of a columnar report (rptProducts) in Print Preview.

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 display multiple records from the many side of a one-to-many relationship—and even include totals.

Figure 37-3 shows an invoice report (rptInvoice) from the Access Auto Auctions database system in Report view.

FIGURE 37-2
A columnar report showing report controls distributed throughout the entire page.

FIGURE 37-3
An invoice report (rptInvoice).

In Figure 37-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.

• Mobile Ad Spend Projections Coda Research has released a report that says that mobile ad spends will rise to a whopping $4.2 billion by...
• Upgrading Wordpress: Troubleshooting HTTP 500 - Internal Server Error With the introduction of Wordpress 2.7 upgrade capabilities for local installations are available right out of the box without the...
• BlackBerry Torch in Action Here is it straight from AT&T Press Conference the Blackberry Torch Coming to AT&T August 12. SPEC: Touchscreen 3.2" High...
• Big Prosper Changes -- 2nd Loans, Authenticated API, 0% on AA, 36% Max Rate, and Portfolio Plans Big changes for Prosper today in new release... Borrowers can now have second loans Authenticated API for access to extended credit and...
• Sarasota Homes For Sale Sell Despite Latest Mortgage Monitor Report! Sarasota homes for sale overlook latest Lender Processing Services' "Mortgage Monitor Report" suggesting foreclosure pipeline bursting - over 13% of...