> Task 3: | Add the credit limit field to the data set

> In order for the report to display credit limit data, you must add the CREDITLIMIT field to the data set.

> 1 | Choose Data Explorer, expand Data Sets, then double-click Customers. Edit Data Set displays the SQL query for the Customers data set.

> 2 | In the query, add a comma (,) after phone.

> 3 | On the next line, add the following text:

> creditLimit
> The modified query should look like the one shown in Figure 8‑2.

> Figure 8‑2 | Query with creditLimit field added

> 4 | Choose Preview Results to verify that the query returns rows with credit limit information.

> 5 | Choose OK to save the data set.

(c) Copyright Actuate Corporation 2009