Hide GroupFooter2 if nothing is GroupHeader1 is not visible....

[jimbofoxman]

I am trying to hide GroupFooter2 if GroupHeader1 is not visible. I setup the following, and tried several different variants with no luck. I have tried it in both the OnPrint and OnFormat in both the header and footer sections.



=IIf([GroupHeader1].[Visible]="0",[GroupFooter2].[Visible]="0",[GroupFooter2].[Visible]="-1")

GroupHeader1 and GroupFooter2 are in the same group. Report is first grouped by "Salesman" and then by "CommCode"

Any thoughts?

[RuralGuy]

I would suggest that the value for which you are looking is numeric (0, -1) and not a string ("0", "-1")

[jimbofoxman]

I had tried that too, should of mentioned it and just tried it again. It doesn't seem to pay attention to whether GroupHeader1 is visible or not, GroupFooter2 is always visible.....no matter what GroupHeader1 is doing.

[RuralGuy]

I would start by making sure you can set the .Visible property to False (0) from some event such as the OnFormat event. What method are you using to make the GroupHeader1 invisible?

[jimbofoxman]

What method are you using to make the GroupHeader1 invisible?

It's only visible because of the second group (CommCode). If that salesperson some have a CommCode sale that grouping doesn't show up.

I also tried it in a Event Procedure with this.... (It's suppose to be groupheader0, not 1. Just a typo in the post)

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)

If [GroupHeader0].Visible = True Then
[GroupFooter2].Visible = True
ElseIf [GroupHeader0].Visible = False Then
[GroupFooter2].Visible = False
End If

End Sub

[RuralGuy]

As I said, as a test try the following and see if the Footer goes invisible.

Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer)

'    If [GroupHeader0].Visible = True Then
'        [GroupFooter2].Visible = True
'    ElseIf [GroupHeader0].Visible = False Then
'        [GroupFooter2].Visible = False
'    End If

   Me.GroupFooter2.Visible = False

End Sub