Wednesday, March 7, 2012

Report joining data from Oracle and SQL Server Datasets?

Re: Report joining data from Oracle and SQL Server Datasets?
I've got a table on an Oracle 9i and another on SQL Server 2005. Any
way to join them into a report using SSRS?Several posting today on this. Either use linked servers and join them
yourself in a stored procedure in SQL Server (be very careful, this is a
dangerous technique) or use subreports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jobs" <jobs@.webdos.com> wrote in message
news:1191964844.528415.256030@.19g2000hsx.googlegroups.com...
> Re: Report joining data from Oracle and SQL Server Datasets?
> I've got a table on an Oracle 9i and another on SQL Server 2005. Any
> way to join them into a report using SSRS?
>

No comments:

Post a Comment