Previous Next

Task 3:  Build a data set for the customer report

In this procedure, you build a data set to indicate what data to retrieve from the Customers table. The customer report that you create later uses this data set.

1  
2  
Customers
Use the default values for the other fields.
*
*
3  
4  
5  
SELECT Customers.customerName,
Customers.customerNumber
FROM Customers
This statement that you created, which is shown in Figure 12-2, gets values from the CUSTOMERNAME and CUSTOMERNUMBER columns in the Customers table.

Figure 12-2 Query for Customers data set

Figure 12-2  Query for Customers data set
6  
7  

Figure 12-3 Data preview

Figure 12-3  Data preview
8  

(c) Copyright Actuate Corporation 2013