>> alternate page print

[Jonathan]

Hi, I want to print terms and conditions on every alternate page.

An aggreement report consists of the client details and items that comprise
the aggreement. A subreport displays the terms and conditions for the
selected aggreement.

Sometimes an aggreement extends onto more than one page (due to the number
of items). I want to print the terms and conditions subreport as the reverse
side to each page of the actual aggreement.

Can I check for the end of page 1, insert the subreport and then check for
the end of page 2, insert the subreport, and so forth?

We want to avoid having a dedicated printer and pre-printed paper with terms
and conditions.

Any ideas or suggestions appreciated

Many thanks, Jonathan

 

[Marshall Barton]

Hi, I want to print terms and conditions on every alternate page.

An aggreement report consists of the client details and items that comprise
the aggreement. A subreport displays the terms and conditions for the
selected aggreement.

Sometimes an aggreement extends onto more than one page (due to the number
of items). I want to print the terms and conditions subreport as the reverse
side to each page of the actual aggreement.

Can I check for the end of page 1, insert the subreport and then check for
the end of page 2, insert the subreport, and so forth?

We want to avoid having a dedicated printer and pre-printed paper with terms
and conditions.

This is a difficult situation. I can only come up with one
way to get that effect and it requires that the detail
section has its KeepTogether property set to Yes. You can
also not use the Page Header section for anything else.

If you can live with those restrictions, then make the page
header section as big as needed, but with room on the page
for one detail section. Place your subreport in the page
header.

Next add a page break control (named pgBreak) to the very
top of the detail section.

Now, add code to the page header's Format event:
Me.Section(3).Visible = (Me.Page Mod 2 = 0)
and add to the detail section's Format event:
Me.pgBreak.Visible = (Me.Page Mod 2 = 0)

The detail section's KeepTogether is required to prevent
part of the detail from printing on the event numbered page
after the subreport. The page break control will prevent a
detail from starting on an even numbered page.

I tested this scenario using A2003 and can not vouch for any
earlier version as there are differences in how some
versions handle making the page header invisible on some
pages.

 

[Jonathan]

Excellant, thanks friend

Jonathan

This is a difficult situation. I can only come up with one
way to get that effect and it requires that the detail
section has its KeepTogether property set to Yes. You can
also not use the Page Header section for anything else.

If you can live with those restrictions, then make the page
header section as big as needed, but with room on the page
for one detail section. Place your subreport in the page
header.

Next add a page break control (named pgBreak) to the very
top of the detail section.

Now, add code to the page header's Format event:
Me.Section(3).Visible = (Me.Page Mod 2 = 0)
and add to the detail section's Format event:
Me.pgBreak.Visible = (Me.Page Mod 2 = 0)

The detail section's KeepTogether is required to prevent
part of the detail from printing on the event numbered page
after the subreport. The page break control will prevent a
detail from starting on an even numbered page.

I tested this scenario using A2003 and can not vouch for any
earlier version as there are differences in how some
versions handle making the page header invisible on some
pages.

 

[FDM]

I am working on a similar report with a slight twist - the detail section
must print only on the odd page numbers with a "signature" page footer and a
full-page "terms" subreport must print on all even page numbers with no page
footer.

I have found several posts that *ALMOST* work, but one of the required
formatting criteria doesn't quite work.

Any suggestions?