Condition Group Footer to be visible based on number of records in detail sectio

[Evan_Robitaille via AccessMonster.com]

I have a report grouped by customer number with account info in the detail
section. I want a subreport in the group footer to be visible if the number
of accounts in the detail section is > 1.

Thanks,
ER

 

[Marshall Barton]

I have a report grouped by customer number with account info in the detail
section. I want a subreport in the group footer to be visible if the number
of accounts in the detail section is > 1.

Add a text box named txtDtlCnt with expression =Count(*)
to the group footer.

Then the footer's Format event can use code like:

Me.subreportcontrol.Visible = (txtDtlCnt > 1)

If you want to hide the entire footer section, use the
section's name instead of the subreport control's name.