total on a 2 column form always print on next page

  • Thread starter Thread starter pierre
  • Start date Start date
P

pierre

Hi all,

I have a report with 2 colums.

In the footer of the report i have a total
and immediately after a small subreport
which is a summary by departement.

Let say my data is 1 and half page long.

I expect the total line and the small report
to be under the last data line in the middle of the second colum

There is lot of space!

But the total and small subreport always print on
the next page.

Why?????

In the format tab for the footer the option are
newpage: no
new line or column: no

help!

regards,
pierre
 
pierre said:
I have a report with 2 colums.

In the footer of the report i have a total
and immediately after a small subreport
which is a summary by departement.

Let say my data is 1 and half page long.

I expect the total line and the small report
to be under the last data line in the middle of the second colum

There is lot of space!

But the total and small subreport always print on
the next page.

Why?????

In the format tab for the footer the option are
newpage: no
new line or column: no
Click to expand...


That's the nature of Down then Across columns and the report
footer. Then left column fills down the page before
starting the second column and the report footer spans the
entire width of the report so there's no room for it on the
last page of data.

To get the summary stuff to display immediately after the
last detail and be within the confines of the column, you
need to use a group footer instead of the report footer.

Use Sorting and Grouping (View menu) to create a group (at
the top of of the list) on a constant expression such as =1
or ="Column Footer". Set the group's Footer property to Yes
and then drag all the controls from the report footer to the
new group footer. Set the report footer's Height to 0.
 
Back
Top