Chapter 9: Presenting Data with Access Reports
329
Clicking the OK button in this dialog box returns you to the sorting screen of the Report Wizard.
There you can click the Next button to move to the next wizard screen.Selecting the layout
Two more dialog boxes affect the look of your report. The first (shown in Figure 9.9) enables you
to determine the basic layout of the data. The Layout area provides six layout choices that tell
Access whether to repeat the column headers, indent each grouping, and add lines or boxes
between the detail lines. As you select each option, the picture on the left changes to show how the
choice affects the report’s appearance.You choose between Portrait (up-and-down) and Landscape (across-the-page) layout for the report in
the Orientation area. Finally, the Adjust the Field Width So All Fields Fit on a Page
check box enables you to cram a lot of data into a little area. (A magnifying glass may be necessary!)For this example, choose Stepped and Portrait, as shown in Figure 9.9. Then click the Next button
to move to the next dialog box.FIGURE 9.9Selecting the page layout
Opening the report design
The final Report Wizard screen contains a checkered flag, which lets you know that you’re at the
finish line. The first part of the screen enables you to enter a title for the report. This title appears
only once, at the very beginning of the report, not at the top of each page. The report title also
serves as the new report’s name. The default title is the name of the table or query you initially
specified as the report’s data source. The report just created in the Chapter09.accdb example is
named rptProducts_Wizard.