Specifications

www.evisions.com Argos - Argos Report Writers Guide Page 41 of 118
Document Version 1.0 – Last Updated 10.18.2010
The new field is now positioned within the Page Header Band. If it is not positioned in the
desired location, drag the field until it is underneath the date.
Creating the Group Bands
Next Group Header and Group Footer bands will be created which will surround the Detail
Band. Since the report is structured to print employees by department name with an
employee count and sum of salaries for each department, use of Groups is necessary.
Within the Band Report Editor, click the “Create a Band Group” icon, then click anywhere
within the image of the report. The following dialog box will appear:
Figure 68 – Adding the Group Header Band
Next, the item that the detail band will be grouped by needs to be entered, therefore click
the ellipsis (…) button to the right of “Group by field or expression”. After entering data
into several dialog boxes that will appear in succession, you will ultimately cause
Argosdata.dept_name to be placed into this field (since the grouping is to be done by
department name).
Figure 69 – Selecting Department Name as the database field to group by
Adding bands to the Report
Click on the desired band icon, then click
anywhere within the report image displayed
within the Editor. The band will then be added
to the report.
“Create a Band Group” icon within Band
Report Editor Toolbar
Band Groups are processed as follows:
Before printing the first record in the Detail
band, the Group Header is printed.
The first Detail record is printed.
The Group-by Field in the next Detail record is
examined:
-If the Group-by Field has the same value as the
previous detail record, the next Detail record is
printed.
-If the Group-by Field has a different value than
the previous record, the Group Footer is printed.
A new Group Header and the next Detail record
is printed.
The Group-by Field can be a simple Data Field
from the dataset, or can be a complex
Expression. If you wish to create a Band Group,
you should ensure that your data is sorted
(ORDER BY) on the Data Field(s) or Expressions(s)
you wish to use.