At least one record at last page

[Alexander Resnik]

I wish to print at least one record at the last page in report. How?

--
Alexander Resnik

[Steve Arbaugh]

Alex:

You can do this by doing the following:

1.) In the on open event of the report, open a recordset on the query or
view that underlies the report and count the records and store the value in
a variable.
2.) Dimension a second variable in the report's declares to use as a record
counter as the report prints.
3.) Add a page break control to the detail section of the report at the top
of the section, but set its visible property to false so that it doesn't
fire.
4.) In the on print event of the detail section increment the counter
variable for each record that is to print. If counter = total, then set the
page break control's visible property to true.

HTH

Steve Arbaugh
ATTAC Consulting Group
http://ourworld.compuserve.com/homepages/attac-cg

"Alexander Resnik" <res...@sed.lg.ua> wrote in message
news:921ta0$csu$1...@hell.sed.lg.ua...

[JPaulSchmidtMBA]

Assuming you have a group header, detail, and group footer and you want to keep
it all together, you might try something like the following:

View | Sorting and Grouping | And for the group in question set the Keep
Together property to be Whole Group.

Best regards,
-Paul

J. Paul Schmidt, MBA
Databases on the Web
http://www.Bullschmidt.com