How do I query a second data source with criteria of each data row result from the first data source

[vinny]

Here is an example:

Data source 1 is from db2:
select id, name, lastorderdate from customers where registerdate > '1/1/2011'

Data source 2 is from mssql:
select ordertype from orders where customerid=? and orderdate>=?

How do I use the id and lastorderdate from the first query to query the second query? Is this possible?

[Alex K.]

Hello,

Unfortunately, in this case, with such a data structure (different databases), this report will not be possible to build in Designer.Web, because Designer.Web does not support scripts in events. Alternatively, you can set a connection to the database in the code of your application, create a DataSet and pass it to the report.

Thank you.