SSRS multiple data sources?

Question

I am using SSRS 2008 to create a report. Is it possible to create a report from multiple data sources? Thanks.

Answer 1

Yes, it is possible to use multiple datasets in SSRS 2008. These data sources can even be different systems entirely, such as a SQL Server connection and an Oracle connection.

You can reference the fields in the report by using datasource.field_name. For example, DataSet.OrderId