page header

[dbb1970]

Hi

i have a report that can have between 4 to 6 pages depending on amount of
data in record. when i have multiple records (eg . 3) i can have up to 18
pages. i want group header to print on first page of record i.e. pages 1, 7,
13 and only want page header to appear on pages that don't have group header
i.e. pages 2-6, 8-12, 14-18. i reset page number in group header format to
"page = 1".
i have tried following code on page header format:
If Page = 1 Then
PageHeaderSection.Visible = False
Else
PageHeaderSection.Visible = True
End If
but on pages 7 and 13 get both page header and group header, and if i place
a field in the page header with control source = [page] the page numbers on
pages 7 and 13 show as 7 and 13 instead of 1.

i know why this is happening, as i am only resetting page number to 1 in
group header which comes after page header, but want to know how to get
around this.

any suggestions would be appreciated.

thanks

 

[Marshall Barton]

i have a report that can have between 4 to 6 pages depending on amount of
data in record. when i have multiple records (eg . 3) i can have up to 18
pages. i want group header to print on first page of record i.e. pages 1, 7,
13 and only want page header to appear on pages that don't have group header
i.e. pages 2-6, 8-12, 14-18. i reset page number in group header format to
"page = 1".
i have tried following code on page header format:
If Page = 1 Then
PageHeaderSection.Visible = False
Else
PageHeaderSection.Visible = True
End If
but on pages 7 and 13 get both page header and group header, and if i place
a field in the page header with control source = [page] the page numbers on
pages 7 and 13 show as 7 and 13 instead of 1.

i know why this is happening, as i am only resetting page number to 1 in
group header which comes after page header, but want to know how to get
around this.

Set the Page header section's Visible to No in design view.
The use the Group Footer section's Format event to set the
page header Visible to False. If you don't have a group
footer, create it and set its Height to 0.

Use the group header section's Format event to make the page
header visible and set the page number to 1.

 

[dbb1970]

excellent

i guess it's all about the logic, as i tried many combinations of making the
header visible and not visible, but couldn't quite get it...although it was
about midnight.

thanks
--
David Benjamin

i have a report that can have between 4 to 6 pages depending on amount of
data in record. when i have multiple records (eg . 3) i can have up to 18
pages. i want group header to print on first page of record i.e. pages 1, 7,
13 and only want page header to appear on pages that don't have group header
i.e. pages 2-6, 8-12, 14-18. i reset page number in group header format to
"page = 1".
i have tried following code on page header format:
If Page = 1 Then
PageHeaderSection.Visible = False
Else
PageHeaderSection.Visible = True
End If
but on pages 7 and 13 get both page header and group header, and if i place
a field in the page header with control source = [page] the page numbers on
pages 7 and 13 show as 7 and 13 instead of 1.

i know why this is happening, as i am only resetting page number to 1 in
group header which comes after page header, but want to know how to get
around this.

Set the Page header section's Visible to No in design view.
The use the Group Footer section's Format event to set the
page header Visible to False. If you don't have a group
footer, create it and set its Height to 0.

Use the group header section's Format event to make the page
header visible and set the page number to 1.

 

[Marshall Barton]

excellent

i guess it's all about the logic, as i tried many combinations of making the
header visible and not visible, but couldn't quite get it...although it was
about midnight.

You probably skipped about a gazillion other combinations.
It's easy to lose The Right One amongst so many
possibilities ;-))

Sometimes, the most productive action you can take is to
knock off and go to bed :-\

Glad you got it working.