I have a report that has an Access datasource, a ODBC datasource and a SQL server datasource. Can I join on multiple datasources without using a linked server ?

You can do this by utilizing subreports. That is the only way I know of however. There is no way to link the datasources together into a single table within SSRS.

Reporting Services does not support joining multiple data sources. Your options are to use OPENROWSET feature of SQL Server or to use the new Lookup function.

Thanks.

Yes, you can do that. Create separate datasets in your report, each that fetches data from a different data source. You could then use the LOOKUP functions available in SSRS to query each of the data sources as required. You should have some sort of a Key column that is common to each of your datasets. Should not be a problem then. With this, you could have a single tablix control bound to a main dataset and can use the LOOKUP functions as expressions within the fields. HTH.

Hi fixitchris, Just give some additional information, Lookup function is only available in SSRS 2008 R2 currently. Lookup could retrieve the value from the specified dataset for a name/value pair where there is a 1-to-1 relationship. For more information about Lookup Function (Report Builder 3.0 and SSRS), please see: http://msdn.microsoft.com/en-us/library/ee210531.aspx Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.