Double Sided Printing - Skip Next Page if Last Page is Odd 1

[Hillary]

I am printing student reports double sided. I don't want one student's report to begin on the back of another therefore if the last page in the student record is odd I want to skip a page, and start printing on the new page.

In Section Expert in Group Header 1 I have checked New Page Before and entered the formula WhilePrintingRecords;
Remainder(PageNumber, 2) <> 0

I did the same in Group Footer 1 for New Page After

I don't know if this matters but Group Footer 1 does not contain records for all students and it is a subreport.

The report is still printing the next student on the back of the previous students record. What am I doing wrong?

Thanks,

Hillary

 

[Madawc]

I'd suggest adding a diagnostic section. Duplicate the formula in a formula field and display it. See what Crystal is actually doing.

Madawc Williams (East Anglia, UK)

 

[Hillary]

I put the formula in Group Footer 1. If Group Footer 1 ends on an odd page the formula returns true. If it ends on an even page it returns false.

Hillary

 

[Madawc]

Fine. So do your page-skip on the values 'true' or 'false' Or just cite the name of the formula field, with not @yourtest selecting 'false'.

What you have is a 'boolian' - if you don't start with 'if', it just determines if the test is true or false.

Madawc Williams (East Anglia, UK)

 

[Hillary]

I goofed when I wrote the original message. Actually, I always need a new page after Group Footer 1 and if the last page of the student record is odd I need 2 New Pages.

For example, a student record ends in the middle of page 2. New Page After forces the next student record to begin on the next page. This works fine. However, if a student record ends on an odd page (ex. page 3) I want to create a page 4 (this also means instead of the student record being Page 1 of 3, 2 of 3 and 3 of 3 it would need to be 1 of 4, 2 of 4, 3 of 4 and 4 of 4). Page 4 of 4 would be blank except for the Page Footer and the next record would start on the next page. I never want a student record to begin on the back side of the paper.

Thanks very much for you help!

Hillary

 

[GMcNamara]

In GF1, check "New Page After".

Right click on GF1 and select "Insert Section Below". In the conditional field for "New Page After" in this new section, enter your criteria from above.

Now you should always get a new page after GF1 and then if the criteria is met, you will also get another new page after the second GF1 section.