Printing reports without blank subreports.

[mnsemple83]

I am trying to print a report without any blank pages. My report consists of several subreports. However, two of these subreports have their own pages and before each one, I inserted a page break. If one or neither of these subreports have any data, the pages that they are on will be blank. I am trying to figure out a way for the report to skip these pages if they do not contain any data.

I was thinking about writing some code that will check the subreport for any data and if not, do not display the subreport. Does anyone have any other suggestions? I'm currently trying things out as I am writing this.



Thanks in advance.

[NTC]

the .HasData method can be used in the OnFormat event of the section to eliminate visibility of that subreport.

of course perhaps just make Can Shrink property to yes may do it sufficiently....

not sure either eliminates the printed page however depending on overall layout.

Hope it helps.

[mnsemple83]

Here's what I did:

In the OnFormat event of the Detail section, for each subreport, here's the code I had written:

If Me.[subreport].Report.HasData = False Then
Me.PageBreak.Visible = False
End If

I also sent the Can Shrink property to yes and everything worked. I do not have any blanks. I hope this helps everyone else out. Thanks for the suggestion.