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 - SubReport_GroupHdrAcrossColumns.mdb
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

SubReport_GroupHdrAcrossColumns.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: SubReport_GroupHdrAcrossColumns.mdb
    Posted: 06 Jul 2008 at 10:52pm
This sample db demonstrates display of group header across all the columns in a 
multi-column report (Column layout: Across, then Down). This feature can be useful 
for displaying page header content of subreports.

Page headers for subreports do not get displayed. The work-around is to include 
the contents of page header in a dummy group header (with its Repeat Section 
property set to Yes).

However, a multi-column report faces the limitation that a group header can cover 
only one column width.

The solution lies in including a sub-subreport in a dummy group header of the 
subreport, to serve as surrogate page header. The contents to be displayed are 
preferably included in report header section of this sub-subreport.

Caution:
In order to prevent distorted display of columns, suitable additional number of blank 
dummy group headers should be inserted so as to ensure that their total number 
equals the number of columns. Repeat Section property of each such group 
header should be set to Yes.

Download Access XP (2000 format):uploads/37/SubReport_GroupHdrAcrossColumns.zip

--

Email: adtejpal@gmail.com
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.