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

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

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 said:
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.
Click to expand...


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.
 
Back
Top