Print Page | Close Window

Report_WithColumnHeaders.mdb

Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Tejpal, A.D.
Forum Description: A.D. Tejpal's Library
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=49
Printed Date: 16 Dec 2017 at 7:26pm


Topic: Report_WithColumnHeaders.mdb
Posted By: A.D. Tejpal
Subject: Report_WithColumnHeaders.mdb
Date 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)

Download Access 2K/XP/2K3/2K7: http://www.rogersaccesslibrary.com/forum/uploads/37/Report_WithColumnHeaders.zip -




Print Page | Close Window