 |
|||
 |
|||
 |
|||
|
|||||||||
|
Crystal Reports Tools: Improve Performance While Saving Time and Money |
|
Crystal Reports: Avoiding Blank PagesUse “Keep Together” to avoid blank pages. There are three objects that can change size dramatically inside a report. They are:
If you place these on your report and they become very large, the “Keep Together” property can result in the entire object being relocated to the next page. Sometimes in these situations, you are happy to see some of the object on the current page and want it to continue over subsequent pages. Remember to untick “Keep Together” on the formatting for the section the object is in. On subreports and memo fields you will also need to untick “Keep Together” on the object format. Now, here's another thing to consider. There are two objects that you might need to have behave differently. A crosstab or a subreport can grow dramatically in size during the processing of a Crystal Report. There may be times when you want the entire object on its own page, but otherwise, you might want to see as much as you can on the current page, and then show the rest on subsequent pages. Untick “Keep Object Together” if you want to see some of the object fit on the current page. You will also need to untick “Keep Together” for that section in the section formatting.
This leads us, obviously, to the related subject of page breaks between groups. You can do this from the Format | Section menu. Crystal Reports: A Beginner’s Guide provides a step-by-step procedure. Here's a short tutorial on that: 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 also 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. |
