It lays out a series of steps for creating a basic report. As we already
have the Data Source created in our Library, go ahead and add the Data
Source from the Library, and click on the Click to skip option for the Data
Source hint.
3. For the Data Set, click on the Click to Perform option. Call the Data Set Get
Employee Sales, and use the following query:
select
EMPLOYEES.EMPLOYEENUMBER,
EMPLOYEES.LASTNAME || ???, ??? || EMPLOYEES.FIRSTNAME name,
ORDERDETAILS.PRICEEACH sales,
ORDERS.ORDERDATE
from
EMPLOYEES,
CUSTOMERS,
ORDERS,
ORDERDETAILS
where
ORDERS.ORDERNUMBER = ORDERDETAILS.ORDERNUMBER
and EMPLOYEES.EMPLOYEENUMBER = CUSTOMERS.SALESREPEMPLOYEENUMBER
and ORDERS.CUSTOMERNUMBER = CUSTOMERS.CUSTOMERNUMBER
and ORDERS.ORDERDATE between ? and ?
Styles, Themes, and Templates
[ 200 ]
4. Create two Report Parameters called startDate and endDate, and bind
them to the Data Set Parameters. For startDate, use the Default value of
2005-01-01, and for endDate, use the Default value of 2005-04-01.
5. When back at the Cheat Sheet, click on Click to Complete for the Data Set.
6. For the Edit Date Binding Cheat Sheet, drag the fields over as in the
following figure. Make the Group Header Row have a Silver Background,
and bold the text.
7. Group by EmployeeNumber. Select the column with the Name/[OrderDate]
fields, and choose Suppress duplicates.
Pages:
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169