Print Page | Close Window

SubReportTwoColBalanced.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=31
Printed Date: 18 Dec 2017 at 5:26pm


Topic: SubReportTwoColBalanced.mdb
Posted By: A.D. Tejpal
Subject: SubReportTwoColBalanced.mdb
Date Posted: 06 Jul 2008 at 10:50pm
The sample db demonstrates balanced display of two columned subreport, 
despite adoption of "Down And Then Across" (D&A) layout.

Normally, "Across And Then Down" (A&D) layout is more convenient for getting 
balanced columns. However, in such an arrangement, there can be awkward blank 
spaces in one column if the contents of adjacent one overflow into multiple rows. 
This can be remedied by adopting D&A layout.

Direct adoption of D&A layout in a subreport does not work as the first column itself 
continues to expand when CanGrow property of the container control is set to 
"Yes". Remedy lies in setting CanGrow property of the subreport control to "No" 
and manipulating its height at run time. This is done by two stage opening. In stage 
1, subreport alone is opened and required heights are stored in an array. These 
values are then used for regular opening of main report in stage 2.

Download Access XP & 2K: http://www.rogersaccesslibrary.com/forum/uploads/37/SubReportTwoColBalanced.zip -




Print Page | Close Window