Grouping Columns of different data source

[MarcoGecoit]

Good Evening
I have three data source, with a common column (ID).
In the first, I have a record with ID, Capital and State
In the second I have three records, with ID and Convention
In the third I have four records, with ID and Organization

How can I group the columns of three data source as follows?



Thanks
Marco

[HighAley]

Hello, Marco.

I have three data source, with a common column (ID).
In the first, I have a record with ID, Capital and State
In the second I have three records, with ID and Convention
In the third I have four records, with ID and Organization

How can I group the columns of three data source as follows?

To give a right answer we need to ask several additional questions:
Is ID unique filed?
Is there any relation between Convention and Organization? For example, does Medical should be in one line with Dr. Smith or it's just two independent columns for ID = 1?

Thank you.

[MarcoGecoit]

Hello,
ID is the relation between the three tables. With ID=1, I've one "Capital" and "State", three "Convention" and four "Organization".
Convention and Organization are independent table with independent columns, in relation with ID



Marco

[HighAley]

Hello, Marco.

ID is the relation between the three tables. With ID=1, I've one "Capital" and "State", three "Convention" and four "Organization".
Convention and Organization are independent table with independent columns, in relation with ID

OK. Now we have a complete picture and have prepared two report templates.

The Simple report demonstrate how to solve the main problem.
And the Report recreate the report like at your first picture. Here the problem with empty cells is solved by using several Events, DataBands and Panels.

If you have some additional questions, please do not hesitate to contact us.

Thank you.

[MarcoGecoit]

Thank you very much! :byebye:

[Andrew]

Hello,

Have a great weekend.

Thank you.