View Full Version : Not Display SubReports with no data


William Smith
08-28-2007, 08:35 AM
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
08-28-2007, 08:49 AM
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
08-28-2007, 09:15 AM
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?