Reports
The Report Designer creates banded reports, where bands are report sections that can be printed once in a report (report header and footer), on each report page (page header and footer), for each data entry (detail band), for each data group (group header and footer), etc.
The Report Designer support the following band types.
Detail band – The central part of a report. Unlike other report bands, you cannot delete this band - the present report structure includes the Detail band in its core. The contents of the Detail band are repeated for every data entry. If you're building a report listing, say, employees, it will be rendered for each employee in the database.
Group Header and Footer – The Group Header and Group Footer bands are shown above and below each group. See Changing or applying data grouping to a report for additional information.
You may use the Group Header bands for grouping by multiple data fields in one of the following ways:
Add several Group Header bands. Specify one group field for each of these bands. This results in nested grouping of the report's data.
Specify several group fields for the Group Fields property of the Group Header band. The data will be grouped by certain combinations of field values.
The Group Footer band is unnecessary without the corresponding Group Header band. When present, it allows customization by providing a set of properties similar to those of the Group Header.
Report Header and Footer – The Report Header and Report Footer are the only types of report bands rendered once per report.
The Report Header is the first band of a report on the first page, not counting margins as they are "out-of-page" zones. The Report Header precedes even the Page Header band. It is the best place for the report's name, company logo, date of creation, author's name and miscellaneous information. If you plan to add a chart that visualizes the report's data, then drop the Chart control onto this band.
The Report Footer finalizes the informative part of the report. It is placed before the Page Footer and Bottom Margin bands on the report's last page. Use the Report Footer for report grand totals or conclusions.
Page Header and Footer – The Page Header and Page Footer bands are located at the top and bottom of every page in a report.
The Page Header/Footer bands are the best place for information that should be printed on every page. For example, use them to display the header of a table which is continued from the previous page.
If you insert page break right after the Report Header (by setting its Page Break property value to After the Band), the Page Footer and Page Header bands will not be printed on the first page.
Page Margin bands – The Top Margin and Bottom Margin bands represent the top and bottom page margins. They are intended for displaying page numbers, or some sort of supplementary information (e.g. current system time or the user name).
Detail Report band (for Master-Detail Reports) – The Detail Report band is a type of band used to incorporate one report into another in master-detail reports.
The Detail Report Band is quite different from the Detail Band since it holds the whole detail report in a master-detail report layout.
There can be an unlimited number of Detail Report Bands nested inside one another, and every new group of bands is colored differently in the Report Designer, as illustrated below:
The Detail Report Band cannot be added to a report via the Report Editor like other band types. To add a Detail Report Band, right-click the Report Designer and in the invoked Context Menu, point to Insert Detail Report. If the bound data source contains a data relationship, the submenu will contain an item with the name of that relationship. Select this item to create a Detail Report Band already bound to a detail table. Otherwise, add an unbound detail report and specify its properties later.
You can manage a report's bands using the Report Editor, which may be invoked either via the Edit and Reorder Bands context link of a report's Smart tag actions list or via any band's Smart tag.
The Report Editor allows you to easily add, remove and reorder a report's bands, and to define their properties.
Another way to add a band of a certain type to a report is to invoke the Context Menu by right-clicking anywhere on a report's surface. On the menu select Insert Band and the appropriate band from the sub menu.