Report Footer - At bottom of last page?

[Guest]

Hi. Is it possible to have the report footer print at the bottom of the last
page, instead of immediately after the end of the detail section (that is
what currently happens in my report).

Thanks in advance.

-Ryan

 

[fredg]

Hi. Is it possible to have the report footer print at the bottom of the last
page, instead of immediately after the end of the detail section (that is
what currently happens in my report).

Thanks in advance.

-Ryan

The Report Footer will only print after the last detail record.
However, you can display the Report Footer data in the Page footer of
the last page.

Make your report as you normally would with the Page Footer and Report
Footer.

Make sure there is a control set to = [Page] & " of " & [Pages] in the
Page Footer.

Then for each control you wish to display on the final page footer,
place an unbound control where it should display.
Set each of these controls Visible properties to No.
(Do not disturb the controls you want to normally display at the
bottom of each page.

Next code the Report' Page Footer Format event:
If [Page] = [Pages] Then
[PageFooterControlName1] = [ReportFooterControlName1]
[PageFooterControlName1].Visible = True
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.
End If

If you have other controls in the page footer that you do not wish to
display on the final page, set them to Not Visible in the Page Footer
event.

You must leave enough Page Footer Height to print these controls.
I see no reason you can't stack these controls on top of your regular
page footer controls and turn Visible properties on and off as
required.

Next code the Report Footer's Format event:
Cancel = True


Then code the Report Header Format event:

[PageFooterControlName1].Visible = False
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.


The Report Footer information should display at the bottom of the
report where the Page footer normally does.

 

[Guest]

Thanks, Fred. This is a crafty solution.

I'm sorry I didn't respond sooner, but I couldn't find this post again.
(new to the message board)

I didn't get to try it in this project bc certain people have changed their
preferences, but i've copied your solution to a text file for later reference.

Thanks again.
-Ryan

Hi. Is it possible to have the report footer print at the bottom of the last
page, instead of immediately after the end of the detail section (that is
what currently happens in my report).

Thanks in advance.

-Ryan

The Report Footer will only print after the last detail record.
However, you can display the Report Footer data in the Page footer of
the last page.

Make your report as you normally would with the Page Footer and Report
Footer.

Make sure there is a control set to = [Page] & " of " & [Pages] in the
Page Footer.

Then for each control you wish to display on the final page footer,
place an unbound control where it should display.
Set each of these controls Visible properties to No.
(Do not disturb the controls you want to normally display at the
bottom of each page.

Next code the Report' Page Footer Format event:
If [Page] = [Pages] Then
[PageFooterControlName1] = [ReportFooterControlName1]
[PageFooterControlName1].Visible = True
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.
End If

If you have other controls in the page footer that you do not wish to
display on the final page, set them to Not Visible in the Page Footer
event.

You must leave enough Page Footer Height to print these controls.
I see no reason you can't stack these controls on top of your regular
page footer controls and turn Visible properties on and off as
required.

Next code the Report Footer's Format event:
Cancel = True


Then code the Report Header Format event:

[PageFooterControlName1].Visible = False
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.


The Report Footer information should display at the bottom of the
report where the Page footer normally does.

 

[Guest]

This looks like it will help me out too
Mike

Hi. Is it possible to have the report footer print at the bottom of the last
page, instead of immediately after the end of the detail section (that is
what currently happens in my report).

Thanks in advance.

-Ryan

The Report Footer will only print after the last detail record.
However, you can display the Report Footer data in the Page footer of
the last page.

Make your report as you normally would with the Page Footer and Report
Footer.

Make sure there is a control set to = [Page] & " of " & [Pages] in the
Page Footer.

Then for each control you wish to display on the final page footer,
place an unbound control where it should display.
Set each of these controls Visible properties to No.
(Do not disturb the controls you want to normally display at the
bottom of each page.

Next code the Report' Page Footer Format event:
If [Page] = [Pages] Then
[PageFooterControlName1] = [ReportFooterControlName1]
[PageFooterControlName1].Visible = True
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.
End If

If you have other controls in the page footer that you do not wish to
display on the final page, set them to Not Visible in the Page Footer
event.

You must leave enough Page Footer Height to print these controls.
I see no reason you can't stack these controls on top of your regular
page footer controls and turn Visible properties on and off as
required.

Next code the Report Footer's Format event:
Cancel = True


Then code the Report Header Format event:

[PageFooterControlName1].Visible = False
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.


The Report Footer information should display at the bottom of the
report where the Page footer normally does.

 

[Guest]

Hi. Last year you replied to this problem.... I need the same help, but am
having difficulty following the actions you specified. Are you still in this
forum?.... Please let me know (specifically, I don't understand where to set
the control (=[Page] & " of " & [Pages]) in the Page Footer.

Thank you.

Thanks, Fred. This is a crafty solution.

I'm sorry I didn't respond sooner, but I couldn't find this post again.
(new to the message board)

I didn't get to try it in this project bc certain people have changed their
preferences, but i've copied your solution to a text file for later reference.

Thanks again.
-Ryan

Hi. Is it possible to have the report footer print at the bottom of the last
page, instead of immediately after the end of the detail section (that is
what currently happens in my report).

Thanks in advance.

-Ryan

The Report Footer will only print after the last detail record.
However, you can display the Report Footer data in the Page footer of
the last page.

Make your report as you normally would with the Page Footer and Report
Footer.

Make sure there is a control set to = [Page] & " of " & [Pages] in the
Page Footer.

Then for each control you wish to display on the final page footer,
place an unbound control where it should display.
Set each of these controls Visible properties to No.
(Do not disturb the controls you want to normally display at the
bottom of each page.

Next code the Report' Page Footer Format event:
If [Page] = [Pages] Then
[PageFooterControlName1] = [ReportFooterControlName1]
[PageFooterControlName1].Visible = True
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.
End If

If you have other controls in the page footer that you do not wish to
display on the final page, set them to Not Visible in the Page Footer
event.

You must leave enough Page Footer Height to print these controls.
I see no reason you can't stack these controls on top of your regular
page footer controls and turn Visible properties on and off as
required.

Next code the Report Footer's Format event:
Cancel = True


Then code the Report Header Format event:

[PageFooterControlName1].Visible = False
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.


The Report Footer information should display at the bottom of the
report where the Page footer normally does.

 

[Guest]

Hi Mike, I'm asking if you or the original solution provider can assist me
with this age old question... If you are still using this group... please
respond.. Thank you.

This looks like it will help me out too
Mike

Hi. Is it possible to have the report footer print at the bottom of the last
page, instead of immediately after the end of the detail section (that is
what currently happens in my report).

Thanks in advance.

-Ryan

The Report Footer will only print after the last detail record.
However, you can display the Report Footer data in the Page footer of
the last page.

Make your report as you normally would with the Page Footer and Report
Footer.

Make sure there is a control set to = [Page] & " of " & [Pages] in the
Page Footer.

Then for each control you wish to display on the final page footer,
place an unbound control where it should display.
Set each of these controls Visible properties to No.
(Do not disturb the controls you want to normally display at the
bottom of each page.

Next code the Report' Page Footer Format event:
If [Page] = [Pages] Then
[PageFooterControlName1] = [ReportFooterControlName1]
[PageFooterControlName1].Visible = True
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.
End If

If you have other controls in the page footer that you do not wish to
display on the final page, set them to Not Visible in the Page Footer
event.

You must leave enough Page Footer Height to print these controls.
I see no reason you can't stack these controls on top of your regular
page footer controls and turn Visible properties on and off as
required.

Next code the Report Footer's Format event:
Cancel = True


Then code the Report Header Format event:

[PageFooterControlName1].Visible = False
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.


The Report Footer information should display at the bottom of the
report where the Page footer normally does.

 

[fredg]

Hi. Last year you replied to this problem.... I need the same help, but am
having difficulty following the actions you specified. Are you still in this
forum?.... Please let me know (specifically, I don't understand where to set
the control (=[Page] & " of " & [Pages]) in the Page Footer.

Thank you.

Thanks, Fred. This is a crafty solution.

I'm sorry I didn't respond sooner, but I couldn't find this post again.
(new to the message board)

I didn't get to try it in this project bc certain people have changed their
preferences, but i've copied your solution to a text file for later reference.

Thanks again.
-Ryan

On Thu, 2 Mar 2006 12:05:18 -0800, Ryan wrote:

Hi. Is it possible to have the report footer print at the bottom of the last
page, instead of immediately after the end of the detail section (that is
what currently happens in my report).

Thanks in advance.

-Ryan

The Report Footer will only print after the last detail record.
However, you can display the Report Footer data in the Page footer of
the last page.

Make your report as you normally would with the Page Footer and Report
Footer.

Make sure there is a control set to = [Page] & " of " & [Pages] in the
Page Footer.

Then for each control you wish to display on the final page footer,
place an unbound control where it should display.
Set each of these controls Visible properties to No.
(Do not disturb the controls you want to normally display at the
bottom of each page.

Next code the Report' Page Footer Format event:
If [Page] = [Pages] Then
[PageFooterControlName1] = [ReportFooterControlName1]
[PageFooterControlName1].Visible = True
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.
End If

If you have other controls in the page footer that you do not wish to
display on the final page, set them to Not Visible in the Page Footer
event.

You must leave enough Page Footer Height to print these controls.
I see no reason you can't stack these controls on top of your regular
page footer controls and turn Visible properties on and off as
required.

Next code the Report Footer's Format event:
Cancel = True

Then code the Report Header Format event:

[PageFooterControlName1].Visible = False
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.

The Report Footer information should display at the bottom of the
report where the Page footer normally does.

You may not have to IF... your report already has a control that is
set to =[Pages] or = "Page " & [Page] & " of " & [Pages]

If it does not, then simply add an unbound control to the Page Footer
that calculates [Pages] (as above).
Note: You can click on Insert + Page Number + Page N of M, or create
your own unbound control with the control source as above. Place it
anywhere in the page footer. If you don't wish to display the actual
page numbers, just make the control not visible.

Does this answer your question?

 

[Guest]

Thank you Fredg. I had overloaded my thoughts, but then later figured it
out. I did not know what you just shared, so I also thank you for that bit of
information. Much success to you in your endeavors.

Hi. Last year you replied to this problem.... I need the same help, but am
having difficulty following the actions you specified. Are you still in this
forum?.... Please let me know (specifically, I don't understand where to set
the control (=[Page] & " of " & [Pages]) in the Page Footer.

Thank you.

Thanks, Fred. This is a crafty solution.

I'm sorry I didn't respond sooner, but I couldn't find this post again.
(new to the message board)

I didn't get to try it in this project bc certain people have changed their
preferences, but i've copied your solution to a text file for later reference.

Thanks again.
-Ryan

:

On Thu, 2 Mar 2006 12:05:18 -0800, Ryan wrote:

Hi. Is it possible to have the report footer print at the bottom of the last
page, instead of immediately after the end of the detail section (that is
what currently happens in my report).

Thanks in advance.

-Ryan

The Report Footer will only print after the last detail record.
However, you can display the Report Footer data in the Page footer of
the last page.

Make your report as you normally would with the Page Footer and Report
Footer.

Make sure there is a control set to = [Page] & " of " & [Pages] in the
Page Footer.

Then for each control you wish to display on the final page footer,
place an unbound control where it should display.
Set each of these controls Visible properties to No.
(Do not disturb the controls you want to normally display at the
bottom of each page.

Next code the Report' Page Footer Format event:
If [Page] = [Pages] Then
[PageFooterControlName1] = [ReportFooterControlName1]
[PageFooterControlName1].Visible = True
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.
End If

If you have other controls in the page footer that you do not wish to
display on the final page, set them to Not Visible in the Page Footer
event.

You must leave enough Page Footer Height to print these controls.
I see no reason you can't stack these controls on top of your regular
page footer controls and turn Visible properties on and off as
required.

Next code the Report Footer's Format event:
Cancel = True

Then code the Report Header Format event:

[PageFooterControlName1].Visible = False
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.

The Report Footer information should display at the bottom of the
report where the Page footer normally does.

You may not have to IF... your report already has a control that is
set to =[Pages] or = "Page " & [Page] & " of " & [Pages]

If it does not, then simply add an unbound control to the Page Footer
that calculates [Pages] (as above).
Note: You can click on Insert + Page Number + Page N of M, or create
your own unbound control with the control source as above. Place it
anywhere in the page footer. If you don't wish to display the actual
page numbers, just make the control not visible.

Does this answer your question?

 

[Ryan T]

Hi Fred,
I was having the same problem. Thank you for your solution. I have one
last problem, though. I get the page footer to only appear on the last page
when I view with print preview, but it appears on every page when I actually
print. Any ideas?

Thank you in advance.

Ryan

Hi. Last year you replied to this problem.... I need the same help, but am
having difficulty following the actions you specified. Are you still in this
forum?.... Please let me know (specifically, I don't understand where to set
the control (=[Page] & " of " & [Pages]) in the Page Footer.

Thank you.

Thanks, Fred. This is a crafty solution.

I'm sorry I didn't respond sooner, but I couldn't find this post again.
(new to the message board)

I didn't get to try it in this project bc certain people have changed their
preferences, but i've copied your solution to a text file for later reference.

Thanks again.
-Ryan

:

On Thu, 2 Mar 2006 12:05:18 -0800, Ryan wrote:

Hi. Is it possible to have the report footer print at the bottom of the last
page, instead of immediately after the end of the detail section (that is
what currently happens in my report).

Thanks in advance.

-Ryan

The Report Footer will only print after the last detail record.
However, you can display the Report Footer data in the Page footer of
the last page.

Make your report as you normally would with the Page Footer and Report
Footer.

Make sure there is a control set to = [Page] & " of " & [Pages] in the
Page Footer.

Then for each control you wish to display on the final page footer,
place an unbound control where it should display.
Set each of these controls Visible properties to No.
(Do not disturb the controls you want to normally display at the
bottom of each page.

Next code the Report' Page Footer Format event:
If [Page] = [Pages] Then
[PageFooterControlName1] = [ReportFooterControlName1]
[PageFooterControlName1].Visible = True
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.
End If

If you have other controls in the page footer that you do not wish to
display on the final page, set them to Not Visible in the Page Footer
event.

You must leave enough Page Footer Height to print these controls.
I see no reason you can't stack these controls on top of your regular
page footer controls and turn Visible properties on and off as
required.

Next code the Report Footer's Format event:
Cancel = True

Then code the Report Header Format event:

[PageFooterControlName1].Visible = False
' Do the same for each other ReportFooter control you wish to show
in the Page Footer.

The Report Footer information should display at the bottom of the
report where the Page footer normally does.

You may not have to IF... your report already has a control that is
set to =[Pages] or = "Page " & [Page] & " of " & [Pages]

If it does not, then simply add an unbound control to the Page Footer
that calculates [Pages] (as above).
Note: You can click on Insert + Page Number + Page N of M, or create
your own unbound control with the control source as above. Place it
anywhere in the page footer. If you don't wish to display the actual
page numbers, just make the control not visible.

Does this answer your question?