Using multiple data sources for one column

[haleb]

We are building a report that we would like to keep as dynamic as possible. What we are trying to achieve is having a certain field pulled from a certain data source based on the id that is associated. Each datasource only has 1 field in them and their is one main data source being used, for sample purposes will call that Datasource 1. Most of the fields come from this main datasource, with the exception of the field we need to be variable.

Sample:
Datasource 1
Datasource 2
Datasource 3
Datasource 4
Datasource 5

Report Structure Sample
Group Header: ID
Databand: Datasource1.field 1, Datasource1.field 2, Datasource1.field 3, variable field, Datasource1.field 4, Datasource1.field 5, Datasource1.field 6

As represented in the above sample, the variable field can come from Datasource 2-5 based on the ID within the group header. How do we set this field to look at any of the datasources based on that group header id?

[Lech Kulikowski]

Hello,

Please provide more detailed information, test data for analysis.

You can add relations between data sources and retrieve data by relation on main band.

Thank you.