Task 3: Add the credit limit field to the data set
In order for the report to display credit limit data, 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 9‑33.
Figure 9‑33 Query showing creditLimit field added
4 Choose Preview Results to verify that the query returns rows that include credit limit information.
5 Choose OK to save the data set.
