Previous Next

Task 4:  Build a data set for the orders subreport

In this procedure, you build a data set to indicate what data to extract from the Orders table. The orders subreport that you create later uses this data set.

1  
2  
Orders
3  
4  
In Query, in Available Items, expand CLASSICMODELS, then expand the Orders table to display the columns in the table.
5  
SELECT Orders.orderNumber,
Orders.orderDate
FROM Orders
WHERE Orders.customerNumber = ?
This statement selects the ORDERNUMBER and ORDERDATE columns from the Orders table. The WHERE clause has a parameter marker for the value of CUSTOMERNUMBER. When the report runs, the orders subreport gets the current CUSTOMERNUMBER value from the customers report.
6  
7  
In Edit Data Set, create a data set parameter to supply the CUSTOMERNUMBER value in the WHERE clause.
1  
2  
3  
o  
o  
o  
o  
103 is one of the values in the CUSTOMERNUMBER column. A default value is required for BIRT Report Designer to run the query for testing purposes.
o  

Figure 13-4 Edited parameter definition

Figure 13-4  Edited parameter definition
4  
Choose OK to confirm your edits to the parameter definition. The parameter definition appears in Edit Data Set.
8  
Choose Preview Results to confirm that the query returns the correct data. Figure 13-5 shows the data rows that the data set returns for customer number 103.

Figure 13-6 Data preview for the orders subreport

Figure 13-5  Data preview for the orders subreport
9  

(c) Copyright Actuate Corporation 2011