Previous Next

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  
3  
creditLimit
The modified query should look like the one shown in Figure 8-2.

Figure 8-2 Query with creditLimit field added

Figure 8-2  Query showing creditLimit field added
4  
5  

(c) Copyright Actuate Corporation 2011