Re: [AccessDevelopers] Multi Column Report

[A.D.Tejpal]

Dawn,       Sample db named  SubReportTwoColBalanced_2K.zip, uploaded to files section, demonstrates balanced display of multi-column subreport despite its layout being "Down & Then Across".       When you click the command button for report preview, the process involves two stage opening. At first the subreport is opened temporarily as an independent report so as to build up an array of required heights of subreport control on each page. It then closes, followed by opening of main report.       The underlying approach could be adapted suitably for your specific situation.   Best wishes, A.D.Tejpal   ----- Original Message ----- From: Crosier, Dawn To: AccessDevelopers@yahoogroups.com Sent: Tuesday, January 17, 2006 00:52 Subject: RE: [AccessDevelopers] Multi Column Report A.D. - Thank you, yes, I would like some help with this.  I tried using your example ReportTwoColBalanced.mdb, but I could not get it to work in the sub report. Dawn Crosier Application Specialist "Education Lasts a Lifetime" This message was posted to a newsgroup.  Please post replies and questions to the group so that others can learn as well. ________________________________ From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of A.D.Tejpal Sent: Monday, January 16, 2006 12:19 PM To: AccessDevelopers@yahoogroups.com Cc: ADT Subject: Re: [AccessDevelopers] Multi Column Report Dawn,     In order to force balanced display of both columns on a two column subreport located in detail section while adhering to "Down & then Across" layout for the columns, following measures are necessary.     (a) CanGrow property of the control (on main report) serving as container for the subreport should be set to "No".     (b) The height of this subreport control as well as the detail section should be manipulated dynamically at run time, taking into account the number of rows contained in the subreport.     (c) If the number of records in subreport is large and likely to spill beyond one page, these should be handled in suitable virtual packets so that vertical height of subreport control needed for displaying the contents of any given packet does not exceed the space available on one page.     If you happen to need further assistance in this regard, I could put together a sample db demonstrating the approach outlined above.     Best wishes, A.D.Tejpal ----------- Please zip all files prior to uploading to Files section. SPONSORED LINKS Microsoft access developer Microsoft access help Microsoft access database Microsoft access training Microsoft access training course Microsoft access programming YAHOO! GROUPS LINKS  Visit your group "AccessDevelopers" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.