Creating a report selecting information from two databases on the same server

[mlemon14]

Does anyone know how I can create a report on reporting services that selects information from two databases on the same sql server? Any help would be grateful Michael

[Lost User]

Create a linked server[^] :)

I are Troll :)

[Md Marufuzzaman]

If both database are is same server then why use linked server.. :confused: :confused: :confused:

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

---

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you. Thanks Md. Marufuzzaman

[i i i]

check the following link http://msdn.microsoft.com/en-us/library/ms345292.aspx[^] or SQL Server 2000 Reporting Services: Creating a report from scratch[^] or Creating Reports with SQL Reporting Service and Visual Studio .NET[^] and can also use/try schema.db.dbo.tbl name

Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it

[Lost User]

Aw, my aplogies, there's no need to create a linked server. You can just prefix the entities that you need to denote the database;

SELECT *
FROM [database].[schema].[table]

E.g.;

SELECT *
FROM Northwind.dbo.Employees

I are Troll :)