Tejpal, A.D. - SubReport_GroupHdrAcrossColumns.mdb

Print Page | Close Window

SubReport_GroupHdrAcrossColumns.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=32
Printed Date: 19 Apr 2024 at 2:58am
Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com

Topic: SubReport_GroupHdrAcrossColumns.mdb

Posted By: A.D. Tejpal
Subject: SubReport_GroupHdrAcrossColumns.mdb
Date 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): http://www.rogersaccesslibrary.com/forum/uploads/37/SubReport_GroupHdrAcrossColumns.zip -