Column height on reports

[Arturo]

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.

 

[Marshall Barton]

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