Can I retrieve a result set from Oracle and then incorporate that result set into my main SQL Server Stored Procedure?

Hi ITBobbyP,

According to your description you want to use data from a Oracle data source into a DataSet which retrieving data from SQL Server. Right?

In Reporting Services, we can have multiple data sources in one project pointing to different database. And we can use separated dataset to retrieve data from different data source. However, it's not supported to combine the two datasets together directly. We can only use Lookup(), LookupSet() function to combine fields from different dataset into one tablix when there are common columns between two datasets. This is the only way to make tow result sets together in SSRS.

Reference:
Lookup Function (Report Builder and SSRS)
LookupSet Function (Report Builder and SSRS)

Best Regards, 

---

Simon Hou
TechNet Community Support