SECTION 4
Lesson 4.1: Organizing Report Data

   

 

 

The default report sections are Page Header, Detail, and Page Footer. If we continue with the example from the last section of this lesson, we can add a title in the Page Header and today’s date in the Page Footer:

 

 

You can click and drag the sections of a report larger or smaller to suit your needs. To do so, move your mouse pointer just above the grey box separating each section. Your mouse pointer will become a double-headed vertical arrow; click and drag to make a section larger or smaller. 

A report is not limited to only five sections, as visible using the Categories report in the sample database:

 

 

The sections of a report are listed as follows:

Report Header

Objects in this section will be visible at the very beginning of a report. You can use this like a title page.

Page Header

Objects that will appear at the top of every page, and under the Report Footer of the first page. In this example, the field names constitute the Page Header.

Detail

Objects that appear in the body of the report. This is usually where the bulk of the information from your table/report will be visible.

Page Footer

Objects that will appear at the bottom of every page. In this example, today’s date and the page numbers appear at the bottom.

Report Footer

Objects that appear at the very bottom of the report. You may wish to put copyright notification or a special thanks page at the end of your report, use the Report Footer section to do this.

 

You might have noticed another section in the above example, the CategoryName Header. This is not a standard header, but rather a customized level of grouping. In this example, this report is used to group all products under a category. The CategoryName Header sorts all of the data based on its own data, in this case the different product categories. We will explore categorization and grouping later in this lesson.