Extra Page In Report

[Vianet News]

Hello,

I am having a bit of an issue with a report that I have. The report consists
of a main report with two sub reports which may or may not appear, depending
on certain criteria. The issue is that I will often have a blank page at the
end of the report with just the footer showing. I have tried adjusting the
widths and heights and confirmed that they are not the problem.

Has anybody encountered this problem before? If so, what steps were taken to
remedy the situation. Any help is well appreciated.

Dave Duffy

 

[DocBrown]

I'm not an expert but you might try the following.

If the number of lines in the sub report can change, then in the
Subform/Subreport properties, make sure the 'Can Grow' and 'Can Shrink' are
set to 'yes'.

I've also found that the vertical space reserved for the subreport, whether
there's data to display or not is determined by the outer box defined for the
subreport. Try shrinking that box height. Click in the square in the upper
left corner of the sub report and drag the lower middle handle to make the
space smaller. I think if the 'Can Grow' property is set to 'Yes' then the
report space will expand to properly display the subreport.

 

[Marshall Barton]

I am having a bit of an issue with a report that I have. The report consists
of a main report with two sub reports which may or may not appear, depending
on certain criteria. The issue is that I will often have a blank page at the
end of the report with just the footer showing. I have tried adjusting the
widths and heights and confirmed that they are not the problem.

Has anybody encountered this problem before? If so, what steps were taken to
remedy the situation. Any help is well appreciated.

That typically happens when the repot footer:
is totally blank
has its ForceNewPage property is set to After Section
has a lot of blank space at the bottom
contains a Page Break control near the bottom

 

[Vianet News]

Marshall,

Thanks for your response. The force new are all set to none and have been
the whole time. There is no blank space at the end of the sheet. The funny
thing is that if we only run the report for one record the problem is not
there.

Thanks again,
Dave

 

[Vianet News]

DocBrown,

Thanks for your response. I set the can shrink and that seems to have fixed
the problem. You have been most helpful. Thanks a lot.

Dave Duffy

 

[Marshall Barton]

I see that you had not set CanShrink for the subreport
controls and/or their section and fixing those settings
resolved the problem. Right?