Suppress Group Footer, conditionally

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a group in a report named "SumType". It groups my report data into
the following groups and allows me to total my revenue and COS, as desired.
However, the "Units" section does not need a total and clutters the report.
I have tried to hide it using IF sumtype = "Units" then hide footer for
group, but that logic hides all the footers--all the time, even for the
revenue/cos totals i require. There are many of these groups on the report.
Any suggestions? Visual sample of what my reports looks like below. Thanks
in advance


Jan Feb Mar Apr
Units 1 1 2 3
 
Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As Integer)
If sumtype = "Units" Then
GroupFooter0.Visible = False
Else
GroupFooter0.Visible = True
End If
End Sub

(seemed to work OK for me, On Format)

Chris
 
Back
Top