Operation Manual

Multiple Section Reports
Using multiple sections in reports
12
Crystal Reports User’s Guide 219
• Adding blank lines under specific conditions (see “Adding blank lines
conditionally” on page 220).
Once you understand the power of multiple sections, you will discover even
more ways to produce the effects you want.
Related topics:
• “Working with sections” on page 214
Keeping variable length objects from overwriting each other
When subreports or other variable length objects are placed above other
objects in one section of the report while the Can Grow option for the variable
length object is toggled on in the Format Editor, that object may overprint
objects positioned directly below it unless you have:
• Expanded the section to fit the maximum size of the object.
• Spaced the objects, allowing enough space for the first object to complete
printing before the second one begins.
You can eliminate this overprinting problem by creating multiple sections in an
area and placing objects below the variable length object in their own section(s).
Now, when the report runs, the section with the variable length object will
finish printing before the section below it prints and you will get the results you
want. See “Combining two or more unrelated reports” on page 478.
Note: Many report objects can use the Can Grow option and can, therefore,
cause overprinting:
• Text fields
• Formula fields
• Memo fields
• BLOB fields
• Subreports
• Cross-Tabs
• OLAP grids