Common data from several data sources in the same data band.

[raulcaster]

I have two data sources which have some common fields. There isn't any other possibility of getting this data (e. g., using a UNION query) because they come from an XML file, specified by different keys. I want to use these common fields in the same databand to sort by one of them. What can I do?

Thanks.

[raulcaster]

Other possibility may be merge my two datasources in one datasource with the fields I'm interested in. But I don't know how can I do it.

[Alex K.]

Hello,

Can you please describe your task in details? And, if possible, send us a data sample.

Thank you.

[raulcaster]

Here's a simple explanation of my problem. The XML file from I get data has two node types which have the fields I need, some of them are common:

...


...


...

In the example attributes "key1" and "key2" are common, but "key3-1" and "key3-2" own to a concrete type.

To get these nodes, I have two data sources, one for each one:

xmlConnection.type1_row: retrives all attributes in "type1_row" nodes.
xmlConnection.type2_row: retrives all attributes in "type2_row" nodes.

Now I need to get these data sources' common data ("key1" and "key2") to show them in the same databand. I also need the data band to be unique, because the table has to be sorted by one of the common fields, treating the data as if they came from the same type, not distinguishing if they own to "type1_row" or "type2_row". I can't change XML file structure because it's used by an application.

I hope this explanation helps you.

Thanks, again.

[Alex K.]

Hello,

Unfortunately, it is impossible to be done in the designer, data source uniting can be made in the application code and then pass the resulting dataset the report designer.

Thank you.