Group Footer

[Chance1234]

I have a report , that has grouping and in the grouping footer is a sub total field,


basicly there are three things that make up the group

Front Office
Back OFfice
Work Flow

now in the footer it sub totals all my items which is brilliant EXCEPT !

on the last bit Workflow i dont want to have subtotals

any idea what I can do >?

 

[VogonPoet]

In the OnFormat event of the group footer include code that looks something like this:

Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
Me.Section("GroupFooter1&quot.Visible = (Me.ControlToReference= "Value to Hide&quot
End Sub


This will set the visible property for the footer to false when the specified control equals the specified value

 

[sko]

VogonPoet,

I think we want to set the visible property to true when the control does not equal "Work Flow" ;-)

Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
Me.Section(&quot;GroupFooter1&quot.Visible = (Me.ControlToReference <> &quot;Value to Hide&quot
End Sub