2 reports per page

[Guest]

I have a report that is grouped by instructor. Each instructor should be on
one page; however, the report is very short & wastes paper since 2 reports
could fit on a piece of paper very easily. Is there a way to print 2 pages
per piece of paper?

 

[fredg]

I have a report that is grouped by instructor. Each instructor should be on
one page; however, the report is very short & wastes paper since 2 reports
could fit on a piece of paper very easily. Is there a way to print 2 pages
per piece of paper?

I'll assume you mean 2 groups on one page, not 2 pages per sheet of
paper.

Try it this way.
Add a Group Footer to the report if you don't already have one.
Add a PageBreak control to the bottom of the Group Footer.
Add an unbound control to the Group Footer.
Set it's control source to
=1
Set it's Running Sum property to
Over All
Name this control CountGrp

Code the Group Footer Format event:
PageBreakName.Visible = CountGrp Mod 2 = 0

 

[Guest]

I get a run time error 424 "object required"

I'll assume you mean 2 groups on one page, not 2 pages per sheet of
paper.

Try it this way.
Add a Group Footer to the report if you don't already have one.
Add a PageBreak control to the bottom of the Group Footer.
Add an unbound control to the Group Footer.
Set it's control source to
=1
Set it's Running Sum property to
Over All
Name this control CountGrp

Code the Group Footer Format event:
PageBreakName.Visible = CountGrp Mod 2 = 0

 

[Marshall Barton]

I have a report that is grouped by instructor. Each instructor should be on
one page; however, the report is very short & wastes paper since 2 reports
could fit on a piece of paper very easily. Is there a way to print 2 pages
per piece of paper?

Another way is to set the group's KeepTogether to Whole
Group, Then all you have to do is enlarge the report's
sections so that the group header, detail and footer take up
a little less than half the page.

 

[fredg]

I get a run time error 424 "object required"

Did you add a Group footer?
Did you add a control to the Footer (as above) and name it CountGrp?
Did you remember to change the name (in the Group Footer Format event)
of the PageBreakName control to the actual name of the page break
control you are using? Access names them in a numerical order, i.e.
PageBreak121.