Skipping Sections of Reports with No Data

[Carmen]

Hi All,
I have a report with only one field on the main report itself and it has 2 subreports. The field on the main report is "SchoolName" and the subreports are linked to it by this field. I force a new page before "SchoolName" on the main report so that each school's data is on a separate page. Sometimes one subreport will have no data so I've used the HasData property to take care of that. So far, no problem. The problem I'm having is when BOTH subreports have no data. I end up with a page that has the School Name at the top and the rest of the page is blank. What I want to do is skip this page entirely, not even print it or preview it, just go on to the next school. Just not sure how to go about skipping certain pages of a report. Any ideas?

Thanks in advance!
Carmen

 

[llkhoutx]

Set the subreoirts can shrink property to yes and have the subreport height equal to a very small value, say .1