Column height on reports


A

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.
 
Ad

Advertisements

M

Marshall Barton

Arturo said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Page Height 0
Reports - Row Heights 2
Report Row Height 1
Maximum Height of a Report 0
Control height on a report 2
height of subform on report 0
sub report height 2
Report Height limit 2

Top