I don't know how to join multiple datatables created in Designer in 1 single Datatable.
I need 1 Datatable with all data in it so I can give that single Datatable to one single Tablix in ReportViewer (rdlc).
Problem: ReportViewer Tablix can accept only one datatable at time and I need them all at once in one tablix.

How did I get stuck here:
* I have added Dataset from Solution Explorer to my Project (ds1)
* Double click on that item gave me Dataset Designer (ds1.xsd)
* Here I have created 4 Datatables with all needed columns, mutually connected with parent-child relationships (one to many, nested).
dt1 is parent to dt2, dt2 is parent to dt3, dt3 is parent to dt4 (dt1 > dt2 > dt3 > dt4).
* On my forms I have binded all my controls to this 4 Datatables and their respective columns so the data is populated hierarhicaly to dataset (as planed).
* I have added ReportViewer Control to one form for reporting purposes and Design a new report (rdlc)...

As I have read in past few days (read: week or two) I need to Join all my datatables to one single (flated) datatable somehow and then feed that DataTable to my Report.
So basicaly I have 2 questions:
1. How to join my 4 datatables? Can I do it from Designer or I must do it in code?
2. If I cant do joining from Designer how will I see this new datatable with all columns from my Report? If I wanna add a Dataset/DataTable to my Report I go to Tab Report Data - New - Dataset - comboToSelectExistingDatasets and if Datatable/Dataset is not created in Designer I can not see it here to add it to work with it.

I will be really really really thankful for any help I can get

Zeljko
vs2010, .net 3.5