Insert page breaks between report groups with two-sided printing

crystal-reports page-break formula-editor
IronicMuffin picture IronicMuffin · Nov 9, 2009 · Viewed 68.2k times · Source

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

dotjoe picture dotjoe · Nov 9, 2009

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

Related questions

(Crystal Reports) Break page after certain # of details?

I am trying to create a check writing report that will work in the following way: The first section of each page of the report will include all line items that will be added into the check. The middle section …

Read More
SAP Crystal Reports runtime for .Net 4.0 (64-bit)

I need a runtime for SAP Crystal Reports for .Net 4.0 (64-bit). I have been searching from the web but not getting any success. Can I get the URL from where can i download this

Read More
How to convert datetime format to date format in crystal report using C#?

i am working c# windows form application and also in crystal report.i am retriving the date from database in datetime format but i like display date only in report,Is any formula field in crystal report help for me …

Read More