Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duplex print Terms and Conditions question??

Status
Not open for further replies.

GolfNFool18

Programmer
May 5, 2002
6
US
All,

I have a report that a customer has started and is having some problems. I am trying to help them without re-designing the report.

Their need was to print a Terms and Conditions Text box on the back of each page of their Purchase Order. They had already created three page headers. One to print on the first page, the second page header is for all remaining pages of the PO except for the reverse page which is the third page header which contains the Terms and Conditions text box. At first they didn't have this working at all. So...

I had place the following formulas in the Section Expert - Suppress formulas..

Page Header A (Page header for 1st page of PO):
PageNumber <> 1 or Remainder(PageNumber,2) = 0

Page Header B (Page header for all succeeding PO Pages):
PageNumber = 1 or Remainder(PageNumber,2) = 0

Page Header C (Page Header for T&C to print on all Odd pages):
PageNumber > 1 or Remainder(PageNumber,2) = 0

This is working fine except for one problem.. The T&C doesn't print on the back of the last PO page because Crystal sees the last page of the PO thus not needing to have another page where the T&C would print.

Any suggestions on how to get the extra page for the additional page header or T&C to print on the back of the last PO page. I hope I haven't been to wordy, and that I have given a clear picture of what is being attempted.

Thanks,

GolfNFool

Troy
 
Oops, sorry the Page Header C formuls is:

remainder(pagenumber,2) <> 0

Not was stated in the original post.

Thanks
 
Try placing another copy of the T&C in a report footer section.

-LB
 
LB,

I tried that but the problem I've had their is that they already have a Report Footer A (contains totals for the PO) that is set to print at bottom of page. However when I add the second Report Footer to print on last page only, the previous page prints the report footer at the top of the page.

I believe this is do to CR calculating the size it needs for all footers before determining the Suppression of the footers. Thus since the T&C is almost a full page in length, it makes the previous footer print hihg on the page and not at the bottom.

GolfNFool
 
LB,

I fixed the problem I listed when I tried this method. the method you gave did fix the problem I originally had of getting the extra page to print the T&C on the last page.

To fix the Report Footer A not printing at the bottom was I had the Report Footer 'Supersection' set to print at Bottom as well. By removing this and leaving both Report Footers to print at bottom I have the desired result.

Thanks,

GolfNFool
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top