Task 3: In this procedure, build a data set to specify what data to retrieve and combine from various tables in the database.
Data Set Type specifies that the data set uses a SQL SELECT query to retrieve the data.
4 In New Data Set —Query, type the following SQL SELECT statement to retrieve the sales total for each territory:WHERE CLASSICMODELS.ORDERS.ORDERNUMBER = CLASSICMODELS.ORDERDETAILS.ORDERNUMBERAND CLASSICMODELS.CUSTOMERS.SALESREPEMPLOYEENUMBER = CLASSICMODELS.EMPLOYEES.EMPLOYEENUMBERAND CLASSICMODELS.EMPLOYEES.OFFICECODE = CLASSICMODELS.OFFICES.OFFICECODEAND CLASSICMODELS.CUSTOMERS.CUSTOMERNUMBER = CLASSICMODELS.ORDERS.CUSTOMERNUMBER
5 Choose Finish to save the data set. Edit Data Set displays the columns specified in the query, and provides options for editing the data set.
6 Choose Preview Results. Figure 18-13 shows the data rows that the data set returns.
Figure 18-13
|
|
Copyright Actuate Corporation 2012 |