Skip to Content
author's profile photo Former Member
Former Member

Subreport -- auto arrange main report according to varying subreport's height

<p>Trying to get the text fields of the main report to format vertically around a subreport that varies according to the # of records the subreport returns.</p><p>For my example, I know that the subreport will return at least 1 record and a max. of 10 records. Don&#39;t need it to total or do anything fancy, just list the rows of data<br /> </p><p>Can the report / subreport be generated so that the 2nd part of the main report is as close as possible to the bottom of the subreport?</p><p>Thanks in advance,</p><p>Keith </p><p>----

</p><p>For example:</p><p> <font color="#006633"><strong>Main report</strong> = </font></p><p><font color="#006633"> Hello John Smith. Thank you for buying a new BRAND OF CAR. bla bla bla</font></p><p><font color="#006633"> You have added the following options to your vehicle:<br /></font> </p><p><font color="#006633"><em>Sub report</em> = </font></p><p><font color="#006633"> Option Price</font></p><p><font color="#006633"> Sunroof $200</font></p><p><font color="#006633"> Heated seats $300</font></p><p><font color="#006633"><strong>Main report</strong> = </font></p><p><font color="#006633"> We hope you enjoy your vehicle. Thank you for buying from ACME CAR SALES.</font></p><br />

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Feb 15, 2007 at 02:38 AM

    There are probably a few ways to tackle this. First thing that comes to mind is in what ever section you have your subreport (eg: Group Header 1), split it into two sections (GH1a / GH1b). Put the subreport in GH1a and your Final line in the GH1b - this will ensure it butts up as closely as possible.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.