Link 2 datasets

HSMorales

I have 2 datasets that are based on stored procedures.
The First dataset has:

Employee_ID and Plan_Name.

The second dataset has:

Employee_ID, Plan_Name, Dependent1
Employee_ID, Plan_Name, Dependnet2
Employee_ID, Plan_Name, Dependent3
Employee_ID, Plan_Name, Dependent4

The second dataset may have any or all of Dep1, Dep2, ... for any Employee_ID and Plan_Name.

How can I link the 2 datasets, based on Employee_Id and Plan_Name, without using a merged datase. I am tying the report to an application that cannot handle a merged dataset.

I created a table for the first dataset, and I would like to display Dep1, Dep2, Dep3, and Dep4 under
the Plan_Name.

Thanks,

Henry Morales
BIRT 3.7.0