	Resources
	Best sellers: cView Report Analyzer cViewSERVER ReCrystallize

	Articles: Administration Advanced Basic Crystal eNL Database Financial Problems Solved Books: CR Books Database Books Developer Books
	Tools: Analyzers Bestsellers CR Schedulers CR UFLs CR Viewers DataBase Tools Graphics International Mail UFLs ReCrystallizePro
	Add'l: About us Contact Us cViewSUITE Ppt Support
	CrystalReports on Steroids

Crystal Reports: Page breaks for a group

One of the reasons for creating a group in Crystal Reports is to have each group start on a new page.

There are several situations which can be easy to control if you understand how the section expert works with "New Page Before" or New Page After." You can use either of these properties to set page breaks, but we find it is simpler to focus on using just one of these.

If you’ve just got one level of group in your report, set your "New Page Before" on Group Header 1. To get rid of the blank first page this creates, you also need to suppress the "Report Header" section.

If you have multiple groups in your report, and you want a page break for a lower level group (e.g. Group 3), suppress the higher level group headers, and set "New Page Before" on your selected group (in this case Group 3). Depending on how often you want to see the higher level group names, you can put the Group 1 Name and Group 2 Name objects in either the Page Header or the Group 3 Header sections.

You can make page breaks conditional. This is ideal for fixed layout reports like invoices and cheques. Use a variable to behave as a line counter and keep track of the lines as you print them.

In the Page Header: WhilePrintingRecords; Numbervar linecounter:=0;

In Each Printing Section (including details): WhilePrintingRecords; Numbervar linecounter:=linecounter + 1;

Conditional "New Page Before" in the details section: WhilePrintingRecords; Numbervar linecounter;

linecounter>60 //or replace the 60 with the number of lines you can print

This technique will also work across multiple subreports. If you are using subreports, you will need to declare the variables as shared. The prize goes to Trevor Nunes of UpTime for working this one through with us.

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.