DataSet Accessing more than one database -- sql server reporting services

NJ
6/8/2006 2:22:28 PM

Is there a way we can create a dataset that extracts data from more than one
database?
Example:
SELECT d.field1, u.field1
FROM Databse1.dbo.tbl_Test d, Databse2.dbo.tbl_User u
WHERE d.ID= u.ID

lior.dba
6/9/2006 1:30:34 AM

you could create a VIEW in database1 that does a select * from
database2.dbo.tbl_user

that way from the report server point of view they both come from the
same database

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : DataSet Accessing more than one database