2 reports per page

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

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
 
I get a run time error 424 "object required"

fredg said:
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
Click to expand...
 
Donna said:
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?
Click to expand...


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.
 
I get a run time error 424 "object required"
Click to expand...

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.
 
Back
Top