In such cases, you are creating an aggregation.
In the following example, we are going to create a simple count of employees that
work at a particular office, using the BIRT Aggregation component.
1. Create a new report called employeeCount.rptDesign.
2. Create a new Data Source based on the Classic Cars Data Source.
3. Create a new Data Set called employeeList.
4. Use the following query:
select
CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBER,
CLASSICMODELS.EMPLOYEES.LASTNAME,
CLASSICMODELS.EMPLOYEES.FIRSTNAME,
CLASSICMODELS.EMPLOYEES.OFFICECODE
from
CLASSICMODELS.EMPLOYEES
5. Drag the employeeList Data Set over to the Report Designer.
6. Select the new Table, and under the Property Editor, select Groups.
7. Create a new Group called groupByOffice, and Group on the OfficeCode.
Chapter 5
[ 101 ]
8. In the Report Designer, select the last column with OFFICECODE and
Delete it.
Working with Data
[ 102 ]
9. Select the Group Header Row with OfficeCode, right-click, and select
Insert|Row|Below.
10. Move the three column Labels to the newly created row.
Chapter 5
[ 103 ]
11. In the Group Footer Row (first column), insert a new Label, and for the text
use Number of Employees.
12. Drag over an Aggregation component to the Group Footer Row,
second column.
13. When you drop the component, a Dialog for the Aggregation will pop up.
Pages:
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112