Examples of reports that start each group in a new row or column

Microsoft Office Access 2003

Report where each group header prints in a new row

Callout 1 In this report, each group header prints in a new row in the left column ...

Callout 2 ... and the detail records print in the next row of the left column, in columns across and then down the page.

The text box for CategoryID is placed in the group header and the text box for ProductName is placed in the detail section. The NewRowOrCol property of the CategoryID header is set to Before & After. The properties on the Columns tab in the Page Setup dialog box are set as follows:

Group Property Setting
Grid Settings Number Of Columns 3
Column Size Width The width of one column in the detail section; for example, 2"
Height The height of one row; for example, 0.25"
Column Layout Across, Then Down Selected

ShowExample of a report that starts each group in a new column

Report where each group header prints in a new column

Callout 1 In this report, each group header prints at the top of a column ...

Callout 2 ... and the detail records print down, and then across the page starting in the next row under the group header.

The design of this report is similar to the one in the previous example, but the NewRowOrCol property of the CategoryID header is set to Before Section, and Column Layout is set to Down, Then Across in the Page Setup dialog box.