content. In tabular format, the total number of lines to be printed equals the number of record sets to be displayed plus one for captions of fields to constitute column headings. . .
Structure of Report in Access A report in Access is designed using seven sections which taken together constitutes the structure of report design. It is not necessary that every report designed in Access must have all the sections that have been described below: Report Header : Report header appears at the top of the report and may include title and other relevant information pertaining to the report. Page Header : Page header appears at the top of every page of the report. It may include a uniform title to indicate that the page belongs to a particular report.
Group Header : The group header and footer are available in a report only if the sort order and grouping levels are also defined on the basis of a field of data source. This is because Group Header and Footers are properties of the field that are used for defining the sort order. Depending on grouping level, the group header appears at the top of each report group. A set of report pages constitutes a report group.
Each group level of report contains a separate group header. Details : The details section, which is also called the main body of a report, contains data from tables or queries that provide the record source to a report. This section is most important as it consists of the main information content of a report. Group Footer : The group footer appears at the bottom of each grouping level and may contain summaries or sub-totals for the grouped data.
Page Footer : The page footer appears at the bottom of each page of the report and is meant to include page numbers, date and time of report generation. Report Footer : The report footer appears once on the last page of the report to include summaries or totals for all data of the report. It is not necessary to incorporate each and