sqlreportbuilderreport-builder2.0

Query useing two databases in SQL Report Builder

I am new to SQL Server Report Builder 2.0 and I need to compare two different databases in one query. Basically I need to check if values from one database table exist in a different database's table.

I know I can add multiple Datasources to my report and access each one with Subreports, but each DataSet that I create can only have one query in it. So how can I go about using one query to access two databases?

Or if there is another way to somehow join my results from multiple DataSets, that would work too.

Also, the databases are on the same server.

Solution

  • Point your DataSource at your master table on the server instead of pointing it at the specific database you want to pull from. As a result you will have to refer to all tables as < DBName >.dbo.< TableName >.< ColumnName >