How can I delete the last blank page in my report ?

[Paul via AccessMonster.com]

I have created a report with subreport. The last page of report is blank
bocos some sub report are invisible. I want to delete the last page of the
report. Id there any command to delete the page in a report or can we print
the selected pages in the report ?

 

[SA]

Paul:

There's two way to resolve this:

1.) Yes you can print only selected pages of the report using the standard
File-> print dialog or in code using the PrintOut method.
2.) If you want to not have the space occupied by invisible subreports, then
size the subreports to .0007 in height (they'll show as a line in the design
view) and set their can grow property to true so that they display
appropriately when there is data.