How can I repositioin a subreport
Posted on 2011-10-26
Great Day, I have a report that displays the data of two subreports. the report has a Report Header; a Page Header, and the two subreports are in the detail section. In design view, these reports are positioned about a 1/4 of an inch apart, and they are both approximately the same size, give or take about 1/16 of an inch. However, the subreport that is on top preserves that 1/4 inch based on the amount of data that is displayed. If 4 or more records are displayed in the top subform, then the 1/4 inch distance is preserved; however if fewer than 4 records are displayed, then this top subform shrinks and there is a large amount of space between the top subform and the one on the bottom.
Is there anyway to alter the position of the bottom subform to maintain its 1/4 inch distance from the top subform when the top subform shrinks? Aesthetically, the gap of white is not too pleasing.
Thanks in advance for your assistance.