I have a requirement to develop a report which has multiple datasources. The main query should be a combination of
datasources from Oracle and SQL Server.
I am trying in this way (this way is working for me when I have both the table in one datasource:
="select * from ORAtb where "+Parameters!P1.Value(1)+" IN(select "+Parameters!P2.Value(1)+ "from SQLtb)"
Table ORAtb is from Oracle and Table SQLtb from SQL Server.
Please suggest what needs to be done.
View Complete Post