Hiding Subreport

[Anita Taylor]

I'm looking for a way to hide a subreport if it contains
no data. I found the HasData property, but I'm not sure
how to use it, where to put it, etc. Any help would be
appreciated.

 

[Marshall Barton]

I'm looking for a way to hide a subreport if it contains
no data. I found the HasData property, but I'm not sure
how to use it, where to put it, etc. Any help would be
appreciated.

Put somthing like this:

If Me.subreportcontrol.Report.HasData Then
Me.subreportcontrol.Visible = True
Else
Me.subreportcontrol.Visible = False
End If

in the Format event procedure of the section containing the
subreport.