page breaks

[todder]

I have a report with 2 groups: one on a Region code and within that, a grouping on Officer code. I would like a page break before every Region group. I also would like a page break before every Officer Group except for the first Officer group in each Region group.

I am able to do this by enabling the "New Page Before" check box in the Region group header and entering the following formula into "New Page Before" in the Officer group header:

previous({TABLE.REG_CD}) = next({TABLE.REG_CD})

The method works well except in cases where the detail lines in the first Officer group within the region group fill up more than one page. In that case the Region group header displays and then the Officer group header displays on the following page instead.

Any insights?

Thanks.