Joining two DataSets

How do you join two datasets in reporting services... one from sql and another from oracle?

Thanks

Currently, datasets cannot be joined on the report. Some options you can explore:

1. Join the datasets at the database level by using the SQL Server linked servers feature.

2. Use a subreport for one of the datasets which can be synchronized with the master with parameters.

3. Use a SQL Server 2005 CLR stored procedure to fetch and join the ADO.NET datasets.

4. Write a custom data extension. This is the most intensive option which I will suggest as a last resort.

|||

Also, read about using the SSIS engine to create your combined dataset.

SSIS has easy and very powerful Transform options which may present you with a better option than writing the code yourself.

Have a look at the article here:

http://blogs.msdn.com/bimusings/archive/2006/07/19/using-a-parameterized-ssis-package-as-a-data-source-for-sql-reporting-services.aspx

Thank you,

LH