Previous Next

Retrieving Data : About data sets : How to join data sets

How to join data sets

You use New Data Set to join two existing data sets into a joint data set.

1
In Data Explorer, right-click Data Sets, and choose New Joint Data Set.
2
Select the first data set for the joint data set from the drop-down list at the left of New Data Set. The columns of the first data set appear in the panel below your selection.
3
Select the second data set for the joint data set from the drop-down list at the right of New Data Set. The columns of the second data set appear.
4
Typically, you select the columns that are common to both data sets. BIRT Report Designer does not prevent you from selecting two unrelated columns as long as both columns have the same data type. Doing so, however, typically does not provide the results you want. Figure 3‑6 shows an example of a joint data set definition.

Figure 3-6 Joint data set definition

Figure 3-6
5
6

(c) Copyright Actuate Corporation 2008