Report Footer on Same Page Solution

[Rich]

FYI:

I have seen many posts here on how to make Access put the Report Footer
totals onto the last page that has detail, not on a last page by
itself.

The best way to do this is to:

1. Add a new field to your underlying source data either via select
query in the data source whereby you would create a new field on the
fly; in the query grid "Type:1", making every resulting record have a
new field named Type with a value of 1. or add a new field to the
underlying source table, call it Type and populate every field with 1.

2. In the report add a group level on the new field Type with the group
footer set to yes.

3. Put all of your normal report footer totals and calculations,
including any sub-reports that you want to 'tack on' to the end of the
'main report' into the Group Footer you just created.

4. Empty the Report Footer (or remove it entirely if you are not using
the Report Header).

This works.

 

[Marshall Barton]

FYI:

I have seen many posts here on how to make Access put the Report Footer
totals onto the last page that has detail, not on a last page by
itself.

The best way to do this is to:

1. Add a new field to your underlying source data either via select
query in the data source whereby you would create a new field on the
fly; in the query grid "Type:1", making every resulting record have a
new field named Type with a value of 1. or add a new field to the
underlying source table, call it Type and populate every field with 1.

2. In the report add a group level on the new field Type with the group
footer set to yes.

3. Put all of your normal report footer totals and calculations,
including any sub-reports that you want to 'tack on' to the end of the
'main report' into the Group Footer you just created.

4. Empty the Report Footer (or remove it entirely if you are not using
the Report Header).

The report footer does not go to the next page unless: It
has its KeepTogether property set and there is no room for
it; It has its ForceNewPage property set to Before Sction;
The previous section has its ForceNewPage property set to
After Section; or The report is set to use multiple Down
then Across columns. Using the dummy group footer only
affects the latter situation because the group footer is
confined to a column, whereas the report footer spans the
entire width of the page.

NOTE: There is no need to create a field in the report's
record source. You can achieve the same effect by grouping
on any constant expression such as =1 or ="My Report Footer"