Merge 2 Data Sources

[ksimmons]

Is there a way in the report designer to merge 2 data sources into one databand? For example, I am supplying one data source to my report via code. I am grabbing another data source (similar structure) from an XML document. I need to group and display the results from both data sources within one report. Can this be accomplished in the report designer?

[HighAley]

Hello.

Yes, it's possible. It could be done in several ways.
If you could create relation between this Data Sources, you can add Data Band with one Data Source and get necessary data from other Data Source using this relation.
Maybe you should set the Cache All Data property of the report to True.

Thank you.

[ksimmons]

If each Data Source is the following structure:
Customer Name
Street
City
Zip
ID Number

How would I relate these 2 data sources? While they both have the same fields, they have different data. I was under the impression that a relation needed a field with the same data.

[Alex K.]

Hello,

Can you please send us a sample report with test data which reproduce the issue for analysis.

Thank you.

[ksimmons]

Attached is the sample report with the 2 XML data sources. They contain data from 2 different systems that need to be combined into this one report. I a, looking for a way to combine the datasources so that I can group by Agency Name and display all of the customer information in one databand. Thank you!

[Alex K.]

Hello,

Unfortunately, it is not possible to show it with grouping or sorting. Please try to combine your data in one data source.

Thank you.