RDLC- use more the one dataset within the same table

Question

In my wpf application i have rdlc reports.

In one of the reports i have a table Countries with idntCountry in one DataSet -and the countryName is in a different DataSet
So my question is: how do i build a table that would take values from more then one DataSets? i tried using the Lookup function but i keep on getting a the error:

Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope

Technically, everything i try doing gives me that error.

What am i doing wrong?

Answer 1

You'll have to join the two datasets. You can do this by creating a new view in your dbms in which you join them by using queries, or you could use linq.

An example of using linq can be found here.