Combining The Information From Two Datasets In Ssrs R2 2008

I am fairly new to ssrs r2 2008. What I am trying to do is create a funnel chart which displays the combined revenue information from two tables in different databases but on the s

Solution 1:

You'll need to UNION the rows from each table together. Since you are going across databases, you need to include the database name in the table reference for the table that the dataset's data source isn't connected to:

SELECT Field1, Field2, Field3
FROM MyTable
UNIONALLSELECT Field1, Field2, Field3
FROM OtherDatabase.dbo.OtherTable

You need to make sure that the account that the report is running under has access to both databases.