Report Footer

[Raymond]

Hi all,
Am having some data which has to be displayed on the last page of the report
at a fixd position. I use the report footer for this but the problem is that
wherever the report ends, the data is displayed just after that..even if it
is the startting of the page...( that's what the job of a report footer
actually is....)

Is there any way by which we can set a fixed position for this data...( lets
say..at left-bottom of screen..)??

As always, your help wud b gr8ly acknowledged...

Raymond

 

[Graham R Seach]

Raymond,

Try adding a Group, and place it in the Group footer.

1. Right-click any section, and select [Sorting and Grouping].
2. Select an appropriate field to goup on.
3. Set the [Group Footer] property to 'Yes'.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Raymond]

No use....already tried it...

Raymond,

Try adding a Group, and place it in the Group footer.

1. Right-click any section, and select [Sorting and Grouping].
2. Select an appropriate field to goup on.
3. Set the [Group Footer] property to 'Yes'.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Hi all,
Am having some data which has to be displayed on the last page of the
report
at a fixd position. I use the report footer for this but the problem is
that
wherever the report ends, the data is displayed just after that..even if
it
is the startting of the page...( that's what the job of a report footer
actually is....)

Is there any way by which we can set a fixed position for this data...(
lets
say..at left-bottom of screen..)??

As always, your help wud b gr8ly acknowledged...

Raymond

 

[Aaron]

Hi all,
Am having some data which has to be displayed on the last page of the
report
at a fixd position. I use the report footer for this but the problem is
that
wherever the report ends, the data is displayed just after that..even if
it
is the startting of the page...( that's what the job of a report footer
actually is....)

Is there any way by which we can set a fixed position for this data...(
lets
say..at left-bottom of screen..)??

As always, your help wud b gr8ly acknowledged...

Raymond

hello nice to meet u
sorry to bother u

 

[fredg]

Hi all,
Am having some data which has to be displayed on the last page of the report
at a fixd position. I use the report footer for this but the problem is that
wherever the report ends, the data is displayed just after that..even if it
is the startting of the page...( that's what the job of a report footer
actually is....)

Is there any way by which we can set a fixed position for this data...( lets
say..at left-bottom of screen..)??

As always, your help wud b gr8ly acknowledged...

Raymond

You can place the Report Footer data in the Page Footer, then just
show the additioanl data on the last page of the report.

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.

 

[Graham R Seach]

Raymond,

Sorry for taking so long to get back to you; I've had to think about this
one for a while. Here is what I've found.

Assuming you want to add a textbox to display at the bottom of the page, and
only on the last page.
1. Add the textbox to the page footer, and set its Visible property to
False.
2. Add the following code to the section's Print event:
Me.MyTextbox.Visible = (Me.Page = Me.Pages)

If you have more than one control to do this to, then add a separate line of
code for each one, or cycle through the section's Controls collection using
some criteria to identify the controls to show/hide (maybe the Tag
property).

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

No use....already tried it...

Raymond,

Try adding a Group, and place it in the Group footer.

1. Right-click any section, and select [Sorting and Grouping].
2. Select an appropriate field to goup on.
3. Set the [Group Footer] property to 'Yes'.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Hi all,
Am having some data which has to be displayed on the last page of the
report
at a fixd position. I use the report footer for this but the problem is
that
wherever the report ends, the data is displayed just after that..even
if
it
is the startting of the page...( that's what the job of a report footer
actually is....)

Is there any way by which we can set a fixed position for this data...(
lets
say..at left-bottom of screen..)??

As always, your help wud b gr8ly acknowledged...

Raymond