multisource report

hi all,
i wonder if any body can help me with this issue:
i have a report about spare balance which read data from
both sql server and oracle dbs ,and do some calc on them,
to return a final balance,the report consist of three
col's one for sql value,one for oracle value,one for the
final balance value. How can i do this ,can a table have
multiple datasets...'!!
or there is any thing else i sould know..
please advice.
thanksCurrent versin of RS does not provide support for joining multiple datasets.
Instead, you can use linked server queries against Oracle and SQL Server
databases and then do a SQL join/union on them.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"teko" <anonymous@.discussions.microsoft.com> wrote in message
news:65b301c4756a$30642870$a601280a@.phx.gbl...
> hi all,
> i wonder if any body can help me with this issue:
> i have a report about spare balance which read data from
> both sql server and oracle dbs ,and do some calc on them,
> to return a final balance,the report consist of three
> col's one for sql value,one for oracle value,one for the
> final balance value. How can i do this ,can a table have
> multiple datasets...'!!
> or there is any thing else i sould know..
> please advice.
> thanks