Not Display SubReports with no data

[William Smith]

Guys this is killing me.

I have several subreports in the detail section of my main report that are nothing more than a label and a text box pulled from different tables. I am providing an example. When there is no data in any of the subreports, a blank is displayed in its place. How do I get the other subreports positioned below to "move up" and save me paper. Not to mention the aesthetics. I have totally exhausted trying different methods. Any help would sure be apprecitated. This doesn't seem to be an impossible task, is it?

 

[boblarson]

Have you tried setting the Can Shrink on the detail section to YES and then in the No Data event of each subform set Me.Visible = False.

 

[William Smith]

Thanks Bob...but no luck. The report still looks the same. Rich earlier had mentioned OnDetail and HasData. But I have tried several combinations and am unsure how to correctly incorporate these. I appreciate your help regardless. Any other suggestions?