Page Break On Field Change

Hi All
I have a group and I want to do a page break on one of the fields inside the group section, when the value in that field changes.

For example, the group is on a field Customer.  The field inside the Customer group is Project#.  I want to insert a page break not only when the Customer changes, but also when the Project# changes within the same Customer group.

I am assuming that a formula can handle this, but I'm new to Crystal.

Any help would be greatly appreciated.

Using Crystal 11.


Who is Participating?
mlmccConnect With a Mentor Commented:
One way would be to add a group on the project number field.  The group header and footer can be suppressed but oyu could use a new page after on the group footer.

The other way is to use a formula onn the NEW PAGE BEFORE on the detail section
Not OnFirstRecord AND Previous({ProjectField}) <> {ProjectFIeld}

RichWAuthor Commented:
Thank you.  That worked!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.