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.

• How To Provision Data Storage Capacity For Content Caching A technician, recently called me up to estimate storage capacity for Internet Caching. The technician, is a part of a...
• 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...
• Spreadsheets Considered Harmful AbstractDecentralized archetypes and write-ahead logging have garnered great interest from both electrical engineers and steganographers in the last several years...
• Bonuses or no bonuses, UK taxpayers to lose out according to RBOS chief According to Royal Bank of Scotland its chief executive, Stephen Hester UK Taxpayers will lose out if the bank unable...
• is this a load of rubbish or is it safe to agree? Version 2.1 (June 27, 2007) END USER LICENSE AGREEMENT NOTE TO USER: BEFORE YOU INSTALL, COPY OR OTHERWISE USE THE...