Reports may
have color and shading and display pictures, business graphs, and memo fields. A special type of
summary tabular report can have all the features of a detail tabular report but omit record details.
FIGURE 9-1
A tabular report (rptProductsSummary) displayed in Print Preview
Columnar reports
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 9-2 shows part of a columnar report (rptProducts) in Print Preview.
298
Access Building Blocks Part I
FIGURE 9-2
A 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 display
multiple records from the many side of a one-to-many relationship??”and even include totals.
Pages:
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704