Understanding the DataWindow painter Design view

For the Tabular, Freeform, and Grid presentation styles, the DataWindow painter Design view is divided into areas called bands. Each band corresponds to a section of the displayed DataWindow object.

DataWindow objects with these presentation styles are divided into four bands: header, detail, summary, and footer. Each band is identified by a bar containing the name of the band above the bar and an Arrow pointing to the band. The Group presentation style has at least six bands, including a second header band for the group headers and a second detail band for the group details.

These bands can contain any information you want, including text, drawing controls, and computed fields containing aggregate totals.

Figure 18-2 shows the Design view for a DataWindow object with a Group presentation style.

Figure 18-2: Design view for a Group presentation style DataWindow

This sample Design view for a Data Window object is divided horizontally into four main areas or bands: Header, Detail, Summary, and Footer. For a group presentation style Data Window, additional header and trailer bands separate each data grouping. The sample shows one group header band and one group trailer band. A shaded bar beneath each band displays the name of the band and an arrow pointing up to its contents. In the sample, the Header band displays the title Employee Report, and also calls the today function. Below that are the individual column headers, Dept I D, Emp I D, and Salary. Below the Header band is the group header band. It lists the Dept I D column for its contents. The detail band lists the other columns, Emp I D and Salary, for its contents. In the group trailer band a sum function is displayed, and the salary will be totaled for each group. The Summary band also calls the sum function that will total the salary over all groups. At bottom left, in the footer band, is a call to the Page function, that will display the page number after the text label "Page".

**Table 18-1: Bands in the DataWindow painter Design view**
Band	Used to display
Header	Information at the top of every screen or page, such as the name of the report or current date
Detail	Data from the database or other data source
Summary	Summary information that displays after all the data, such as totals and counts
Footer	Information displayed at the bottom of every page or screen, such as page number and page count