Report headers and footers

[Paradigm]

I have a report that has a subtotal in each page footer.
I need to also print a list of people the report is to be issued to at the
bottom of the last page.
The problem is that if I put the list of people in the report footer it is
printed above the page footer on the last page.
Ideally I would like a report footer that is printed below the page footer.
Is there a way of doing this.
Alec

 

[Allen Browne]

Presumably you already have a way to get these names into a text box?

If so you can set the Visible property of the text box to No unless it is
the last page of the report.

The formation event of the Page Footer would contain:
Dim bShow As Boolean
bShow = (Page = Pages)
If Me.[Text0).Visible <> bShow Then
Me.[Text0].Visible = bShow
End If

 

[Paradigm]

Since the page footer does not have a cangrow and canshrink property, then
the space occupied by the info that is to be on the last page will appear as
large blank areas on all the other pages. There is insufficient space for
this.
Alex

Presumably you already have a way to get these names into a text box?

If so you can set the Visible property of the text box to No unless it is
the last page of the report.

The formation event of the Page Footer would contain:
Dim bShow As Boolean
bShow = (Page = Pages)
If Me.[Text0).Visible <> bShow Then
Me.[Text0].Visible = bShow
End If

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a report that has a subtotal in each page footer.
I need to also print a list of people the report is to be issued to at the
bottom of the last page.
The problem is that if I put the list of people in the report footer it is
printed above the page footer on the last page.
Ideally I would like a report footer that is printed below the page
footer.
Is there a way of doing this.
Alec

 

[Allen Browne]

There is no chance of printing another section on any page below the Page
Footer section.

You could programmatically identify the last record in the report, and when
the Detail section reaches that record, set the report's PrintSection to
False, MoveLayout to True, and NextRecord to False in the Format event of
the Detail section, until the report's Top property indicates it is far
enough down the page. Then set NextRecord to True, and the Report Footer
will appear below that, but still above the Page Footer.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Since the page footer does not have a cangrow and canshrink property, then
the space occupied by the info that is to be on the last page will appear
as
large blank areas on all the other pages. There is insufficient space for
this.
Alex

Presumably you already have a way to get these names into a text box?

If so you can set the Visible property of the text box to No unless it is
the last page of the report.

The formation event of the Page Footer would contain:
Dim bShow As Boolean
bShow = (Page = Pages)
If Me.[Text0).Visible <> bShow Then
Me.[Text0].Visible = bShow
End If

I have a report that has a subtotal in each page footer.
I need to also print a list of people the report is to be issued to at the
bottom of the last page.
The problem is that if I put the list of people in the report footer it is
printed above the page footer on the last page.
Ideally I would like a report footer that is printed below the page
footer.
Is there a way of doing this.
Alec