A Join between two data bands or data sources

[jkoo]

Hi,

It might be about Union of two data rather than join of two data.

Anyway let's have two data tables 'Task1', 'Task2" which have two columns 'Name','Date'.
What I want to do here is to create a report to show all data from 'Task1' and 'Task2' but I want to sort by 'Date'.

If I join two tables and then pass it to StimulSoft, I think it's possible.
But it's not my option. I cannot pass one joined table. I can pass only one dataset includes two Tables 'Task1' and 'Task2' to the report.
In that case, is there any way to create a report for combined result from two table with 'Date' sort column in the StimulSoft?

Date Name
==== =====
11111 xxxxx <= it's from "Task1"
22222 yyyyyy <= it's from "Task2"
33333 xxxxxx <= It's from "Task1"

[HighAley]

Hello.

Unfortunately, there is no build-in methods to do it.
You could join them with code, for example, in the Begin Render event of the page.

Thank you.

[jkoo]

Is there any sample code for that?

Thanks

[Alex K.]

Hello,

Please try to use the Merge() method of DataSet object for this task.

Thank you.