Invoice Duplex Printing

[bearieco]

I am trying to create an invoice where some invoices will have multiple pages where other invoices are single pages.

The report contains two groups
[ol][li]Current Month Activities[/li]
[li]Open invoices from previous months[/li][/ol]
Both of these are in the group footer for its group

Here is what I am trying to do:

If the invoice is 1 page
[ul][li]Print the invoice on the front of the page[/li]
[li]Print the mailing address on the back of the page[/li][/ul]

If the invoice is more than 1 page
[ul][li]Print the contents of the invoice on the front of each page (with nothing on the back of the page)[/li]
[li]On the last page of the invoice print the mailing address[/li][/ul]

The 1 page invoice works like a charm.

Please help - I have been pulling my hair out over this one.

Thanx,
Barbara

 

[Ngolem]

Hmmm...tough one...I assume you have a duplex printer...and you cannot turn this on/off

How about this

create a separate bank detail section...ahead of the true detail section...in it place a formula called

@SplitPage
********************** start formula **********

WhilePrintingRecords;
numbervar SplitFlag;

if Remainder(PageNumber,2) = 0 then
Splitflag := 1
else
Splitflag := 0;

********************** end formula **********

Place this in the empty detail section and suppress the whole detail section...this way it is calc'd but not displayed...and it sets the Split flag to 1 only when on an even page.



in the section expert....in "New Page before" conditional function make the formula

WhilePrintingRecords;
numbervar SplitFlag;
SplitFlag = 1

this means that you should skip that page when on an even page

Place your mailing info in the report footer with the "New Page Before" checked

This might work

Jim

 

[bearieco]

Hi Jim,

Thank you for your response.

I could not get this to work. The pages printed correctly (front & back). But, when it was skipping the back of the page the data that should have been on that page was NOT moved to the next page. The data was just left out of the report. ARG

Thanx,
Barbara

 

[Ngolem]

that should not happen if you set it up properly

make sure you have nothing else checked off in the Section Expert

you just suppress the detail section with the {@SplitPage} formula,(ie. DetailA)

and put the other formula in the conditional for "New Page Before" of the detail section b

in the Section expert.....make sure all boxes are UNCHECKED in the overall Detail section

the Section expert will look like this

Detail (nothing checked or conditional)
Detail a (Have the "Supress(no Drill down" checked)
Detail b (Have the conditional formula in
the "new Page before" conditional formula)

I think this will work as I have described