2. Import the dsClassicCars Data Source from the ClassicCarsLibrary.
rptlibrary.
3. Create a new Data Set called topEmployees using the following query:
select
EMPLOYEES.EMPLOYEENUMBER,
EMPLOYEES.LASTNAME,
EMPLOYEES.FIRSTNAME,
ORDERDETAILS.PRICEEACH
from
EMPLOYEES,
CUSTOMERS,
ORDERS,
ORDERDETAILS
where
CUSTOMERS.CUSTOMERNUMBER = ORDERS.CUSTOMERNUMBER
and CUSTOMERS.SALESREPEMPLOYEENUMBER = EMPLOYEES.EMPLOYEENUMBER
and ORDERDETAILS.ORDERNUMBER = ORDERS.ORDERNUMBER
and ORDERS.ORDERDATE between ? and ?
4. Create two date parameters??”startDate and endDate??”and link them to the
two Data Set Parameters in topEmployees.
Styles, Themes, and Templates
[ 190 ]
5. Insert the topEmployees Data Set into the Report Design by right-clicking on
it and choosing Insert in Layout under the Data Explorer.
6. Create a Grouping on EmployeeNumber in the Table, and call it
employeeNumberGrouping. The following screenshot is the Table after the
Grouping has been created.
7. In the Table Properties, click on the Binding tab, and then click on the Add
Aggregation... button.
Chapter 8
[ 191 ]
8. Create an aggregation on the PRICEEACH field and set it on the
employeeNumberGrouping. We are going to sum the PRICEEACH field
into a new field called totalEmployeeSales.
9. Hit OK. Create a second aggregation called totalSales.
Pages:
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164