Oracle and SQL query in one rdl

I am currently creating a query wherein all of the records returned
from an SQL Server table will have to be queried against an Oracle
database. The following algorithm describes how I intend to do the
report:
* Get the start and end dates (report parameters)
* Run the following SQL Server query:
select ID from SQL_server_table
where logtime >= startdate
and logtime <= enddate
* For each ID returned from the SQL server table
* Query the Oracle datebase
select info1, info2 from Oracle_table
where id = ID_from_SQL_server
* Report on the SQL_Server.ID, Oracle_info1, Oracle_info2
How should I do that in an SRS?
Thank you so much in advance!Read up on subreports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<joychua97@.gmail.com> wrote in message
news:1143818223.627860.28200@.i39g2000cwa.googlegroups.com...
>I am currently creating a query wherein all of the records returned
> from an SQL Server table will have to be queried against an Oracle
> database. The following algorithm describes how I intend to do the
> report:
> * Get the start and end dates (report parameters)
> * Run the following SQL Server query:
> select ID from SQL_server_table
> where logtime >= startdate
> and logtime <= enddate
> * For each ID returned from the SQL server table
> * Query the Oracle datebase
> select info1, info2 from Oracle_table
> where id = ID_from_SQL_server
> * Report on the SQL_Server.ID, Oracle_info1, Oracle_info2
> How should I do that in an SRS?
> Thank you so much in advance!
>