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!
Bruce L-C [MVP] - 31 Mar 2006 20:14 GMT
Read up on subreports.

Signature
Bruce Loehle-Conger
MVP SQL Server Reporting Services
>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
[quoted text clipped - 18 lines]
>
> Thank you so much in advance!