Tuesday, January 3, 2012

Crystal Reports : Forcing a Page Break for Each Group

When using Groups in Crystal Reports (Insert | Group), you may wish to have each group appear on it's own page. Or at the very lest force a new page before the "next" Group prints.

This is easily accomplished through the Section Expert window.

1. Right-click in the "Sections" area to left hand side of your Designer.
2. Select "Format Section".

The Section Expert window will let you modify how each Report Section behaves.
In our case, we want to create a new page after each Group is printed.

1. On the left hand side of the Section Expert, select your Group Footer.
2. Then, on the right hand side, select "New Page After".

This will force the beginning of each Group to start on it's own Page. Another way to do it would be to use the "New Page Before" setting; you may find yourself trying each to get a feel for how they behave.

This can make the difference between a "messy" to read report and a nice, organized looking report. Try it!

3 comments:

Gaurang said...

Use of both of mentioned methods will leave either first or last blank page.
User will need to add a condition, this StackOverflow post explains ...
http://stackoverflow.com/questions/1704296/how-can-i-insert-page-breaks-between-groups-in-crystal-reports-with-two-sided-pr

Justin Hill said...

Thanks for the post! Certainly, almost all aspects of Crystal can be controlled conditionally. This is something we get into often during our monthly Crystal webinar. To sign up, visit www.marksgroup.net, thanks!

Hifni Nazeer said...

gr8 article!