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

[Former Member]

<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 />

[todd_hanna · Accepted solution]

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.