groupheader.page from pageheader_format

[GavinP]

Is it possible to get the groupheader page from the format sub of the pageheader.

I have a report, with several subreports, one of which contains several pages of data. On the main page, I've put into the pageheader the column headers of the sub report, which shouldn't be shown on the first page of the group.

At present, i've got the following in my pageheaderformat,

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

If Me.Page = 1 Then

PageHeaderSection.Visible = False
Else
PageHeaderSection.Visible = True
End If



End Sub
which obviously works for the first group.

What I would like is something along the lines of the following
Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)

If Me.Page = groupheader0.page Then

PageHeaderSection.Visible = False
Else
PageHeaderSection.Visible = True
End If
end sub

I'm sure there must be a way to do this, but I can't get it to work.

Gavin

 

[Remou]

I do not understand why the Repeat Section option has not been used with the Group Header.