Prev: Report not printing all groups
Next: page header on main report with subreports
From: Arturo on 26 Jun 2008 13:55
My report has enough data to create 2 columns.
All margins are 1", portrait, and there are
report and page headers. What happens is that
my subtotals in the report footer show up on
page 2. This is fine when there is more data and
more pages are needed.

When there is one page of data, and there is
a full column (9 inches)and a short column 2
(4 inches), how can I make the columns equal
and have my footer show up on one page?

Thank you.
From: Marshall Barton on 26 Jun 2008 15:06
Arturo wrote:

>My report has enough data to create 2 columns.
>All margins are 1", portrait, and there are
>report and page headers. What happens is that
>my subtotals in the report footer show up on
>page 2. This is fine when there is more data and
>more pages are needed.
>
>When there is one page of data, and there is
>a full column (9 inches)and a short column 2
>(4 inches), how can I make the columns equal
>and have my footer show up on one page?


If at all possible, use Across then Down snaking.

If that's not feasible, then try modifying the report's
record source query to include a calculated field:

ColNum: (SELECT Count(*) FROM table WHERE ...) \ 2

Then you can add a top level group on the ColNum field and
set this group's header section's NewRowOrCol property to
Before Section

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Report not printing all groups
Next: page header on main report with subreports