I hope someone can help with a problem I have with Crystal Reports

 

I have a report set up as follows

 

Report Header - Surpressed

Page Header

Group Header #1

Group Header #2 - Surpressed

Details

Group Footer #2 - Suppressed

Group Footer #1a

Group Footer #1b

Report Footer - Suppressed

Page Footer - Suppressed

 

I run this against a few records so takes up quite a few pages.  Each record is at least 4 pages but can go up to 10.

 

What I want to do is to have each record starts on an Odd number so I can print the whole report double sided so they can be seperated.

 

I have a pagenumber running in the report and this resets itself after the group footer.  e.g first group goes up to 6 next goes up to 5 .......

 

To try to help me to get this to work I have put a formula in Group Footer #1b to suppress is an odd by using this formula

 

Remainder(PageNumber,2)=1

 

This didn't work as I had hoped.

 

The page number now doesn't reset after each record but continues till the end of the report.

 

Any idea why this has happened or if there is another way I can get this to work?

 

Any help is much Appreciated.

 

Dave