Columnar report, total prints on new page if > 1 col detail

Persistent and very annoying problem here, find no mention
in KB. I solved it in one report, but have no clue how I
did it. Perhaps someone here will have the solution!

I generate many different client lists, often using 2-3
columns, and usually need a count at the end of the list.

If the report detail only uses one column, the total
(Report Footer) prints at the bottom of the column. If the
detail moves onto the 2nd column (at least in a 2-column
report, perhaps in a 3-column report as well, definitely if
it moves into the 3rd column), the report adds a new page,
prints the page header and report footer on the
otherwise-blank page. I need the report footer (text box
using running-sum "counter" text box in the detail as its
data source) to print at the end of the last column,
presuming that column isn't full.

With the report I "fixed" it seems that monkeying with
column widths and margins in the Page Setup led to the
desired result, although I may have changed properties
elsewhere as well. I'm hopeful you'll set me straight!
-Bob

Bob wrote:

Persistent and very annoying problem here, find no mention
in KB. I solved it in one report, but have no clue how I
did it. Perhaps someone here will have the solution!

I generate many different client lists, often using 2-3
columns, and usually need a count at the end of the list.

If the report detail only uses one column, the total
(Report Footer) prints at the bottom of the column. If the
detail moves onto the 2nd column (at least in a 2-column
report, perhaps in a 3-column report as well, definitely if
it moves into the 3rd column), the report adds a new page,
prints the page header and report footer on the
otherwise-blank page. I need the report footer (text box
using running-sum "counter" text box in the detail as its
data source) to print at the end of the last column,
presuming that column isn't full.

With the report I "fixed" it seems that monkeying with
column widths and margins in the Page Setup led to the
desired result, although I may have changed properties
elsewhere as well.


The report footer spans the entire width of the page so it
can not appear under any one column (unless there is only
one column).

You should use a group footer since group header/footers are
confined to the column width. This is easily done by
specifying a top level group (View menu - Sorting and
Grouping) with a constant expression such as =1 and
specifying Yes in the group footer property.

Now you can move the total text box from the report footer
to the group footer to display the total at the bottom of th
elast column regardless of how many columns you're using.
--
Marsh
MVP [MS Access]

Awesome! I knew it had to be something obnoxiously simple!
Thanks for the tip!

-Bob
-----Original Message-----
Bob wrote:

Persistent and very annoying problem here, find no
mention
in KB. I solved it in one report, but have no clue how I
did it. Perhaps someone here will have the solution!

I generate many different client lists, often using 2-3
columns, and usually need a count at the end of the list.

If the report detail only uses one column, the total
(Report Footer) prints at the bottom of the column. If
the
detail moves onto the 2nd column (at least in a 2-column
report, perhaps in a 3-column report as well, definitely
if
it moves into the 3rd column), the report adds a new
page,
prints the page header and report footer on the
otherwise-blank page. I need the report footer (text box
using running-sum "counter" text box in the detail as its
data source) to print at the end of the last column,
presuming that column isn't full.

With the report I "fixed" it seems that monkeying with
column widths and margins in the Page Setup led to the
desired result, although I may have changed properties
elsewhere as well.


The report footer spans the entire width of the page so it
can not appear under any one column (unless there is only
one column).

You should use a group footer since group header/footers
are
confined to the column width. This is easily done by
specifying a top level group (View menu - Sorting and
Grouping) with a constant expression such as =1 and
specifying Yes in the group footer property.

Now you can move the total text box from the report footer
to the group footer to display the total at the bottom of
th
elast column regardless of how many columns you're using.
--
Marsh
MVP [MS Access]
.