Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Tejpal, A.D.
  New Posts New Posts RSS Feed - Report_WithColumnHeaders.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login


Please consider donating $1 per sample downloaded, (find out why here)

Report_WithColumnHeaders.mdb

 Post Reply Post Reply
Author
Message
A.D. Tejpal View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 30 Jun 2008
Status: Offline
Points: 192
Post Options Post Options   Thanks (0) Thanks(0)   Quote A.D. Tejpal Quote  Post ReplyReply Direct Link To This Post Topic: Report_WithColumnHeaders.mdb
    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: uploads/37/Report_WithColumnHeaders.zip

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links


Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down