Creating reports and dashboards | Stimulsoft community forum

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"

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.

Is there any sample code for that?

Thanks

Hello,

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

Thank you.