Information After Last Group

  • Thread starter Thread starter Telesphore
  • Start date Start date
T

Telesphore

How to add an information only after the last group.
The report will be printed in two columns.

Thank you.
 
Consider using the Report footer which will print after all groups have been
printed.
 
Thak you

If I print the report on one column, the information is printed exactly
after the last group.
But if I print on two columns, the information is printed at the top of a
new page.
 
You must have some property set wrong. I just tested by creating a two
column report and it prints the Report Footer section immediately following
the last record in the report.
 
Telesphore said:
If I print the report on one column, the information is printed exactly
after the last group.
But if I print on two columns, the information is printed at the top of a
new page.
Click to expand...


If you are using Down then Across snaking, then the page may
be filled in the first column and, since the report footer
uses the report's entire width, the footer must be on the
last page. If you use Across then Down, the columns fill
evenly anf the report footer will (if there is space) appear
on the same page.

You can create a top level group (on a constant expression
such as =1) with footer and use that instead of the report
footer because group footers are confined to the column
width.
 
Thank you

This is exactly what you said. But I must use Down then Across snaking.

Thanks again.
 
Was the group footer suggestion unacceptable or did you have
trouble getting it to work?

There is another way, but it is rather complex. It involves
using the report's record source query to calculate a record
number (based on one or more fields with a unique sorting
order) and using that to calculate the page and column
numbers. The report can then be sorted on those three
values so that Across then Down snaking comes out looking
like Down then Across.
 
Thank you very much.

I am so sorry I didn't read your last paragraph on your October 2nd message.
Then I was out for 5 days.

With the a top level group (on a constant expression
such as =1) with footer, it is perfect.

Thanks

Telesphore

Marshall Barton said:
Was the group footer suggestion unacceptable or did you have
trouble getting it to work?

There is another way, but it is rather complex. It involves
using the report's record source query to calculate a record
number (based on one or more fields with a unique sorting
order) and using that to calculate the page and column
numbers. The report can then be sorted on those three
values so that Across then Down snaking comes out looking
like Down then Across.
--
Marsh
MVP [MS Access]

This is exactly what you said. But I must use Down then Across snaking.


"Marshall Barton" a écrit
Click to expand...
Click to expand...
 
Back
Top