Using a field of a dataset in another dataset in paginated report

[karthikaganesh]

Hello,

I'm having two datasources, one is Azure SQL database and other is ODBC.

Here in the query I want to compare columns of table from datasource1 and datasource2.

Eg.
datasource1(Azure SQL Database)

select date1,date2 from dataset1

datasoruce2(ODBC)

select invoicedate from dataset2

where invoicedate < dataset1. date1

Is there any way to do this? 

Thank you in advance

[josef78]

Create internal hidden parameter and set default value from datasource1.

In datasource2 use this parameter in where causule (with @ prefix)