Task 4: Build a data set
Figure 1-11 New Data SetThe SELECT statement that you created, which is shown in Figure 1-12, gets values from the CUSTOMERNAME, CONTACTLASTNAME, CONTACTFIRSTNAME, and PHONE columns in the CUSTOMERS table.Figure 1-12 SQL SELECT statement in Edit Data Set
7 Choose Preview Results to make sure the query is valid and that it returns the correct data. Figure 1-13 shows some of the data rows that the query returns.Figure 1-13 Data rows returned by a SQL SELECT statement
(c) Copyright Actuate Corporation 2013 |