This sample db demonstrates provision of headers for each column of multi-column
reports. Four styles are covered as follows:
(a) R_MultiCol_AcrossAndDown - Natural group header (Column layout: Across
And Down)
(b) R_MultiCol_DownAndAcross - Natural group header (Column layout: Down
And Across)
(c) R_MultiCol_AcrossAndDown_DummyGrpHdr - Dummy group header (Column
layout: Across And Down)
(d) R_MultiCol_DownAndAcross_DummyGrpHdr - Dummy group header (Column
layout: Down And Across)
For displaying meaningful dynamic information in column headers, styles (a) and (b)
above should suit. If no natural grouping is feasible or if merely static information is
to be displayed in column headers, styles (c) and (d) can be adopted.
Some additional notes:
In a multicolumn report, following alternatives could be considered for ensuring
presence of headers for each column.
1 - DA layout (Down, Then Across)
This will provide the appropriate heading (as per group header) for each
column. However, when available data is less than the space available on a page,
the last populated column won't be balanced. A new column commences only
when the previous one gets filled to its full height.
2 - AD layout (Across, Then Down)
This gets you balanced columns but group heading appears only for the first
column. The situation can be remedied by adopting a work-around. This involves
creation of redundant group headers on the field meant to serve as column
heading. In a report with three columns, three identical group headers are required
to be created.
Certain points that need to be kept in view, while dealing with group headers
meant to serve as column headings, are reiterated below.
(a) In sorting and grouping dialog box, KeepTogether property of the group
should be kept as No.
(b) RepeatSection property of group header section should always be kept as
Yes. The implications of NOT DOING SO are.
(i) In DA layout, the column heading will appear only for the first column on
first page. None of the columns on subsequent pages will carry any
heading.
(ii) In AD layout, if adequate number of group header sections have been
inserted, the column headings will appear for all columns on the first page.
Subsequent pages will not carry any column headings.
5 - Version: Access 2K/XP/2K3/2K7 (Access 2000 File Format)
Download Access 2K/XP/2K3/2K7: http://www.rogersaccesslibrary.com/forum/uploads/37/Report_WithColumnHeaders.zip -
|