Hide subreports when null

[dssrun]

I know someone has answered this question before but i couldn't find a good answer. I have a subreport linked in the footer of a group, so there are about 5 different instance of just one subreport. I want to hide only the instances where that subreport is null. Microsoft help has the code below to hide a subreport when there is no data. However, this hides all subreport instances in each footer when in fact there is data since the first instance has no data. Is there a way to use a for each statement here to cycle through each instance of the subreports or is there another way to accomplish this? Thanks.

Me!rptsubReason.Visible = Me!rptsubReason.Report.HasData

[boblarson]

Did you put it in the ON FORMAT event of the group footer?

[NTC]

you have to make it visible too.

once non visible, always non visible (and vice versa) so you have to put in a statement for both as it compares each page as it builds.....

hope it helps.

[dssrun]

Does that mean I need a statement like

    If Me!rptsubReason.Report.HasData = True Then
        Me!rptsubReason.Visible = True
    Else
        Me!rptsubReason.Visible = False
End if

[dssrun]

I feel stupid, I was testing this out when I hit "report" or "layout" and it only works when you hit print preview or when you are ready to export the report. This seems to do the trick in the GroupFooter Format Event

Me!rptsubReason.Visible = Me!rptsubReason.Report.HasData

[boblarson]

you have to make it visible too.

NTC:

This code:

Me!rptsubReason.Visible = Me!rptsubReason.Report.HasData

Does just that - it makes it visible when it has data and not visible when it doesn't.