Re: [AccessDevelopers] Multi Column Report

[A.D.Tejpal]

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 --------------   ----- Original Message ----- From: Crosier, Dawn To: AccessDevelopers@yahoogroups.com Sent: Friday, January 13, 2006 01:48 Subject: [AccessDevelopers] Multi Column Report I have a report which is landscaped.  I have it set for two columns. The flow of the report across the columns is Down then Across. The details of the report is a subreport.  I have it set for two columns.  The flow of the report is Down then Across.  What I would like to have happen is for the columns of the subreport to be only as long as to the body of the page the main report is on. Basically, I am attempting to duplicate a booklet type report and minimize the amount of white space in the report. I can change the flow of the subreport to Across and then Down, but if an item in the subreport happens to grow, then blank lines appear in the columns. Can this be done? Dawn Crosier Application Specialist "Education Lasts a Lifetime" Please zip all files prior to uploading to Files section. 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.