|
|
|
|
|
Navigator > Setup > Report Designer
Reports are made up of bands laid on the page in a sequence determined by the Band type. Bands are separated by a light line across the page width. Bands must be named; you can change band names. The naming convention for bands is to prefix the name with 'band', for example bandHeader. By default, Labels for the Band type and band name appear in grey. Band name positioning is determined from Report Designer preferences.
The Design Window Toolbar provides buttons to Insert, Duplicate, Move and Delete bands.
Bands have properties. To select a band, click the band in the Design Window, or select the Band Name from the drop down at the top of the Property Editor. If a component is selected, select it's band by pressing Shift+Esc to select the component's parent. When you select a band, the properties will appear in the Property Editor.
Band Types
The Band Type (BandType) determines the print order of bands, regardless of where bands appear in the Design Window.
Watermark |
Prints before other bands have been printed on the page. |
Page Header |
Prints first at the start of every page. |
Title |
Prints after the Page Header only on the first page of the report. |
Column Header |
Prints before Detail Bands on each page. It is usually used for column headings. |
Group Header |
Prints at the start of a new group. |
Detail band |
Prints once for each record in the report. |
Group Footer |
Prints at the end of a group. |
Summary |
Prints once on the last page of the report after all Detail bands. |
Page Footer |
Prints last at the end of every page. |
Overmark |
Prints after all other bands have been printed on the page. |
Introduction |
Similar to a Summary band, but prints before all Group and Detail bands. |
Band Selection
Detail, Group Header and Group Footer bands must be selected in the Query bands (Custom reports) or Iterators (Document designers) before they will iterate when the report is run.
Click 
Select Bands (F2) on the Query bands selection or Iterator Bands field to select bands. Within an Iterator, bands are executed in the order they are listed in Band selection, use the Move Item Up / Move Item Down arrows to order the bands.
The Execute Report 
(Ctrl+R) button checks and warns if any Detail, Group Header and Group Footer bands are not selected. The warning is not triggered when the report or document is Run outside the designer.
OK |
Cancel Execute report and select the bands. |
Ignore |
Continue Execute report ignoring the warning. |
Cancel |
Cancel Execute report. |
Band Order
The ordering or bands on the printed report depends on the band types, see above. For example, it makes no difference if a Page Footer band appears in the Design Window before or after a Page Header band as the precedence of the printed output of these bands is already determined.
The order of the bands in the Design Window is only used for the report when the above ordering does not determine the band order. This applies if you have more than one band of a given type. Then for Detail, Group Header and Group Footer bands (iterated bands), ordering is selected within the query bands or iterators. For other than Detail, Group Header or Group Footer bands (non-iterated bands), the order within the Design Window applies. For example, if you have two Page Header bands they will both be output at the top of each page but in the order shown in the Design Window.
Bands can be turned on and off using the Enabled property during report generation. You can have more than one band of a given type to provide a way to turn sections of the report on or off during report generation (using the band's Enabled property).
Watermark and Overmark bands cannot be exported to a spreadsheet or text file.