Insert page breaks between report groups 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.

Answer 1

You can do this with the onfirstrecord, pagenumber and the onlastrecord keywords.

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 

Answer 2

Open the Section Expert screen. Select Report Header and check "Suppress (No Drill-Down)". Then select in the group header select the group you want to page break and check "New Page Before".

Answer 3

This Works fine if I need Page Break on one Group. How do I do if Page Break on Multiple Groups?

I found answer.. Using Next(Field) or Previous(Field), I added below condition and worked fine.

In Next Page Before formula:

Not onFirstRecord and ({table.field} <> previous({table.field}))