Forcing section break to odd pages

Hi - I'm new to this forum and fairly new to Crystal. Using 9.0. Because we print two-sided, I need to force a section break to start on next available odd numbered page so that I can treat the printed sections as separate documents (e.g. I don't want 1st page of new section to print on back of preceeding section). These sections are anywhere from 10 - 18 pages in length, and it is a huge report - over 11,000 pages. I'm pretty sure that there is a way to do this but I don't have time to fumble around with it. I already have 10 hours in this one report!

Thanks in advance
RobinI wrote a report recently that needed something simular, prehaps you can try this. The report prints a list of people at a specific place. Sometimes the place (group one) has lots of people and stems onto two pages and other times it fits on one page. As I'm duplex printing, I need to check whether the pages are even or odd and thus to include a page break or not.

In the section expect, I added a new group footer. In both group footer 1a and 1b I checked the 'new page after'. Then in group footer 1b, I added

Right (ToText(PageNumber),1) in ["0","2","4","6","8"]

which causes my report only to add a blank page after group one has finished if the current page number ends in any of the values above.

Hope it helps.

Forcing Column Headings

Hi...

I have a report that does not use the detail line. It groups the information it needs and prints out in the lowest section heading (Product Type).

The problem arises when we have an employee ( next group up) who has worked on loads of product types in the date range selected.

The report prints perfectly except that when it skips to a new page we only get the page heading, not the section headings.

I have tried moving the section headings to the page headings - report "looks" fine, but does not work as it fails to recognise any changes in the groups.

Anyone any ideas how I can "force" it to print a heading when a certain number of lines have been printed??

Am new to Crystal so am sorry if this is a stupid posting...Will checking the 'repeat group header on each page' box do the trick for you?|||Thanks for the response.

Was not aware of that box, and finally tracked it down.

Unfortunately tried it and it did not change anything. Will carry on experimenting, but if you have any other ideas they will be gratefully received!!

Thanks again|||Update....

The more digging round I did, the more your suggestion seemed to be what I wanted, so I could not understand why it did not work.

So I went back and tried it again... and it now works!

No idea what I did before - can only assume I put it in the wrong section. I can only blame it being early and a lack of caffeine...

But it now works, as I said.

Many, many thanks for your help.sql