Stop a subreport from printing

[robert demo via AccessMonster.com]

I have a report with a subreport. Before displaying this report from my
application, I allow the user to select what they would like to display on
the report. Printing of the subreport is optional.

I'm using the following code:

If PrintProfileProposalFlag = True Then
Me.SubReport1.Visible = True
Else
Me.SubReport1.Visible = False
End If


The subreport currently prints on the last page of the report. When the
flag is set to false, the subreport is not displayed, but a blank page
still prints.

How do I suppress the printing of this last page when the flag is set to
false?

Thanks.

 

[Guest]

Set the "can shrink" property of the sub report , and the section here the
sub report is in, to true.