993bc7a2__Chris_Webb_s_BI_Blog___Page_2__0
[1] No real solution here, though SSRS developers have wanted to be able to do joins on datasets for a while. The new R2 lookup functions partly address this. [2] Create joins between PowerPivot tables [3] PowerPivot has the obvious advantage here, although for SSRS you can argue that in most cases any data integration should be happening upstream in your ETL. [0] 
Integrate that data
Random Thoughts | Chris Webb's BI Blog | Page 2
0