Specifications

www.evisions.com Argos - Argos Report Writers Guide Page 28 of 118
Document Version 1.0 – Last Updated 10.18.2010
Creating a Basic Banded Report
Example 1
Introduction
This example utilizes the Employees table within the sample database and will produce a
report (see figure below) of employees grouped by Department Name. The example
demonstrates the use of a Page Header Band, Group Header Band, Child Band, Detail
Band, Group Footer Band, and Summary Band.
Figure 36 – Banded report using various Band Types
The figure above illustrates the band types that are used in this example as follows:
• The Page Header Band (Employee Roster) prints at the top of the page and contains
the date and page number of the report.
• The Detail Band contains the data obtained from the Report query.
• The Detail Band is surrounded by Group Header and Group Footer Bands. Grouping is
done by Department Name.
• The Group Header Band contains the name of the department.
• The Child Band always prints beneath the Group Header Band and contains column
titles
• The Group Footer Band shows the number of employees and sum of salaries for that
department.
• The Summary Band prints at the end of the report and contains the total number of
employees and salaries for the entire company.
Definition of Bands:
Page Header Band
Prints at the top of every page.
Page Footer Band
Prints at the bottom of every page.
Title Band
Prints on the first page immediately below the
page header band.
Summary Band
Always prints on the last page, immediately
before the Page Footer Band.
Column Header Band
Always prints at the top of the page after the
Title Band.
Detail Band
This is where the data from the Report query is
printed. The band will print repeatedly for each
record. It will keep printing between the other
bands until it runs out of room, then a new page
will start.
Child Band
Linked to any other band
and prints
immediately after it. The band that it is linked to
is called its parent band.
Group Bands(Group Header/Footer)
Group Header and Group Footer bands
surround a detail band. Used to structure data
into groups, based on a data field or expression.
Sub-Detail Band
This band displays one dataset while being
linked to another dataset (called the Master). As
each record is printed in the Master dataset,
Argos will loop through the Sub Detail dataset.
Sub-Detail Bands are not as efficient as other
methods and should be used only when other
methods cannot be used.
Loop Band
Contents of a loop band will be printed
repeatedly. The user inputs the number of times
the band is repeated.