title: Can I "join" across datasources in SSRS?
body: <p>I've got two datasources, one Oracle and one Sql Server. Due to circumstances that predate me (as in it was like this when I found it) some columns in the Oracle database contain PKs from lookup tables in the Sql Server database.</p>
  
  <p>I am attempting to create a Sql Server Reporting Services report that will combine data from both the Oracle and Sql Server database; where the data to be reported is partially from Oracle but some of the values needs to be looked up in Sql Server.</p>
  
  <p>I've got the datasources. I've got the DataSets. I just can't figure out how to show both datasets in the same tabular report.</p>
  
  <p>Is this possible? If so how so? I'd rather not resort to a db link in one or the other databases as I'd like to handle this on the reporting side.</p>