Subreport is putting blank lines in the report

[maggiesda]

Here's our problem:&nbsp;&nbsp;We have a .rpt which includes one subreport.&nbsp;&nbsp;We want to produce a summary report, for which the subreport does some of the calculations.&nbsp;&nbsp;Our problem is that the subreport section in the main report is creating blank spaces in the report.&nbsp;&nbsp;The subreport is the only object in the section, which is a group footer in the main report.&nbsp;&nbsp;We are unable to suppress the subreport section because when we do the subreport doesn't calculate.&nbsp;&nbsp;The &quot;Can Grow&quot; option is on.&nbsp;&nbsp;<br>Many thanks in advance for any tips.

 

[LindaC]

How about supressing the group footer if blank? <p>LindaC<br><a href=mailto:lcastner@co.orange.ny.us>lcastner@co.orange.ny.us</a><br><a href= > </a><br>

 

[maggiesda]

If you're refering to the &quot;Suppress blank section&quot; option in the Format Section dialog, we have that checked.<br><br>Thanks.

 

[MalcolmW]

Make the section that the subreport is in very short, by shrinking the height of the subreport, then shrink the section height.&nbsp;&nbsp;The subreport will grow to the correct height when it has something to show, otherwise you will just get the minimum height.<br>Also check that the subreport itself doesn't have any things that are taking up space, like empty report headers, footers, etc. <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>

 

[LMCRYER]

You could also go into the subreport itself and suppress each section, it will make it show on your report as &quot;blank&quot; but it will still pass your variables through to your main report. You can then make the section where you have your subreport as small as possible so that it doesnt really &quot;show&quot;...

see crystal kbase article c2007600 for using the shared variables and also kbase article c2005853 for shrinking blank subreports...

Lisa
cryerlisa@hotmail.com