Bands

A report is made up of horizontal bands. Your report can contain as many or as few bands as necessary, and each band can contain one or more lines. As you create a report, assign each band a type. The order of types assigned to bands determines the order in which text and fields appear in the report.

Band properties

Property

What it does

Heading

Appears at the top of the report.

Group 1

Determines the first level of grouping.

Group 2

Determines the second level of grouping.

Group 3

Determines the third level of grouping.

Detail

Provides the detail for the body of a report.

Subtotal 1

Select Subtotal 1 when you want to subtotal data from Group 1.

Subtotal 2

Select Subtotal 2 when you want to subtotal data from Group 2.

Subtotal 3

Select Subtotal 3 when you want to subtotal data from Group 3.

Total

Select Total when you want to total data from the entire report.

No Print

Select No Print when you want to include a field in the report so a calculated field calculates correctly, but do not need to include the information in the report.

You can place the field on a separate band and assign the band the No Print type. When you generate the report, the band is not included.

You do not have to use every type of band in a report. For example, you create a new report using the following bands: Heading, Group 1, Group 2, Detail, Detail, and Total. Notice that two detail bands exist. As you build a custom report, you can create multiple detail bands to accommodate text, graphics, and fields you want the report to supply. All bands expand to accommodate the size of a graphic or text you enter in the custom report. Similar bands must be grouped together and you cannot have bands with the Blank type in the body of the report.

About band properties

When you select a band, you can change its properties by clicking the Edit properties (Band Properties button ) button.

Report band properties

Property

You can:

Font

Set the font, font style, and size for the entire band.

Color

Set the color of text and objects for the entire band.

¼ height

Set the band to one-quarter of the normal band height.

½ height

Set the band to one-half of the normal band height.

Full height

Set the band to normal height.
  1. In 13-3 Report Writer, open the report into which you want to insert a band.
  2. Click the band button immediately below the band where you want to insert the new band.
  3. On the toolbar, click the Insert a row (Insert a band button ) button.
  1. In 13-3 Report Writer, open the report from which you want to delete a band.
  2. Click the band button of the band you want to delete.
  3. On the toolbar, click the Delete (Delete a Band button ) button.