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.
In order for the report to display credit limit data, you must add the CREDITLIMIT field to the data set.