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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

back page

Status
Not open for further replies.

KayKay

MIS
Jan 11, 2001
15
US
using cr9
sql db

I am printing invoices and need to print terms and conditions on the back page of each page (using a printer with duplexing capabilities).

Should I use a subreport for the Term and Conditions page or can I create another group and force it (somehow) to print every other page (assuming multiple page invoices)?

Invoices are not always multi-page.

Help
 
The following worked when I tested it, and it doesn't require a subreport. First, go to the section expert and highlight the group header->new page before. Then insert a new page header section so that you have page header_a and page header_b. (You should have your usual page header fields in page header_a.) The select page header_a->suppress->x+2 and enter:

remainder(pagenumber, 2) = 0

Then format page header_b with:

remainder(pagenumber, 2) <> 0

Add your terms and conditions to a text box in the page header_b and then right click on the text box and choose "Object Size and Position" and hard code the text box height so that only page header_b will display on the page.

So that the last group will also have terms and conditions on the back page, you will need to add the text box again in the report footer, and format it with "new page before."

-LB
 
Thanks LB,

I actually already had multiple page headers a through d and I added page e with your suggestions. I applied the formatting to all above page headers (above the new page e header).

I have tried the suggestions and I am having a hard time setting the format size for only the new page header to fit on the back page(s).

Can you please help with this?

Karen

 
Actually, I think the size you make the text box is not the key factor, but instead the size you make the page header_b. In design mode, try dragging the lower boundary of page header_b until it reaches about 10 inches on the left-hand ruler. Then check in preview to see if you are seeing any records below it and keep resizing as necessary. If you make the section too big, you will get an error message and will know you need to size it a little smaller. The size of the text box just has to be large enough to hold your narrative.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top