on 03-04-2009 12:35 PM
I have a report which prints out Invoices. These invoices include term's and conditions as the last page. I have an external program which emails out the batch of invoices to the accounts department. If they print off the invoices double sided, i could have the problem in where an invoice is three pages including the T&C's and then there could be another invoice after that. If there is, the T&C's would be on the page and if you flip it over, you will have the start of a new invoice. I hope i've made myself clear here. lol. So my question is, how can i make it so that the T&C's print out on an even page?
Before i get to confused (trust me it doesn't take long) This is how the format is now. I'll put a bit of detail in to show you how its working as well.
My design is like this below
Report Header
Page Header
Invoice To Addresses/Delivery To Addresses/Invoice Number
Group Header1 Home/Export
Group Header2 Customer Code
Group Header3 Invoice/CreditNo
Details
Items/Prices/U.O.M
Group Footer 3a
Order Status/Sub Total
Group Footer 3b
Export Detail/Customizable Text
Group Footer 3c
T's and C's
Group Footer2
Group Footer1
Page Footer
Report Footer
I do not have any Section Expert settings other than supress in the Group Headers.
Then i have in the Details, 'Keep Together'.
Then in Group Footer 3a, 'Keep Together'.
Then in Group Footer 3b, 'Reset Page Number After' and 'Keep Together'.
Group Footer 3c, has 'New Page After and
remainder(pagenumber,2)<>0
in the formula criteria.
Then the rest of the Group Footer's and the Page Footer and the Report Footer are supressed.
Through these setting's, when i run the multiple invoices off, i get the header staying on the same page as the T's and C's plus the Page Header goes on to the second page where Group Footer 3a is sometimes depending on how long the detail. I know this has something to do with the Detail. Also the T's and C's are still printing out on Odd Pages. Please help me get to the objective in where:
I want the Page Header to appear only on the Invoice Page and not the Term's and Condition's. I want the T's and C's to print on an 'Even' page because this is an invoice run in where the user may print to a printer double sided. If this happens the T's and C's may end up on a page in where the other side of the same page might be the start of a new Invoice.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Raghavendra seems to be right that resetting the page number after group footer 3b will cause issues. By the time the group 3c footer is run, the page number will always be 1.
I think what you need is New Page After on footer 3c (unconditional; I assume the T&C will end somewhere in the middle of the page, and is not exactly 1 page long), and a new group 3 footer (3d) with a conditional New Page After. If moving the Reset page Number After to footer 3d does not work (would that be conditional too?), you might need to add yet another group 3 footer (3e) with that option set.
HTH,
Carl
Hi Raghavendra, i'm resetting the page number on 3b because on the Page header i have (Page n of m). If i don't reset it here, it will include the T's and C's as a page number and i don't want to do this. Just tried your theory as well and it still doesn't work. The T's and C's is also exactly one page long.
Also, how can i make the T's and C's appear at the top of the page and be one page long? So, say if i have an invoice which rolls over to 2 pages. The 2nd page of the page header will say (Page 2 of 2). Then i want the T's and C's to print on an even page even though the next page should be the third page. So basically the T's and C's page should not include the Page Header but should be kept together with the invoice. I hope this makes sense :-s.
Cheers
Do you want the T&C to start on the even page, or the first page of the invoice to be on an odd page? (This is not necessarily the same question...) Assuming the later, this may do the trick:
- Group the report on invoice number, if it is not already. (I'm assuming it is...)
- Add two new group header formats before the current invoice number group header.
- Remove the New Page Before checkbox on the old group header (if it was checked previously).
- Check the New Page Before checkbox in the first new group header. Make this header 1 pixel tall.
- Put the following into the formula field for New Page Before in the second new group header format (Basic Syntax):
formula = (PageNumber / 2 = int(PageNumber / 2))
The first new group header will push the invoice to the top of the next page (which I pretty much assume the report is already doing). The second new group header should conditionally skip to a second new page if the page number (which would be the page number of the top of the new invoice) is even, forcing the invoice to start on an odd page.
I have not tried this, so there are no guarantees, of couse!
HTH,
Carl
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, its placed in the Invoice Group Footer 3c
My design is like this below
Report Header
Page Header
Group Header1 Home/Export
Group Header2 Customer Code
Group Header3 Invoice/CreditNo
Details
Group Footer 3
Group Footer 3a
Group Footer 3b
Group Footer 3c
Group Footer2
Group Footer1
Page Footer
Report Footer
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.