How can I insert page breaks between groups in Crystal Reports with two-sided printing?

Question

In group expert options I have set Keep Group Together, which makes sure a new page is set.

With two-sided printing enabled, how can I make sure that a new group always forms on a new sheet of paper? Can this be done in the formula expert? Is there some way of checking if the page I'm on is even or odd and insert a page from there? Just asking leading questions because I'm not familiar with what is possible with Crystal's formula editor. BTW, This is Crystal XI Enterprise Server.

Any tips are appreciated. Thanks.

Answer 1

You can do this with the onfirstrecord, pagenumber and the onlastrecord keyword

On the group header section "New page before" formula

not onfirstrecord //so every group (except the first) starts on a new page

On "New page after" formula

//to keep the group from starting on even page but make sure the last page is not blank
remainder(pagenumber, 2) = 1 and not onlastrecord