Report_WithColumnHeaders.mdb |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 07 Jul 2008 at 10:38pm |
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)
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |