Merging datasources -- sql server reporting services

greatdane
2/28/2007 1:08:25 PM

I need to be able to merge two different results from two different
datasources.
One datasource is connected to Oracle and the other one to SQL Server
The parent record comes from Oracle and may have detail data in SQL.
I want to display results in one single report services table.

Amarnath
3/2/2007 5:41:03 AM

Use linked server from sql server to connect to Oracle and access using
Stored Proc, so that you can get a single report table. Other option is use
Sub Report for parent child reports.

Amarnath

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Merging datasources