sql server reporting services: Is anyone aware of whether you are able to use data from a SQL Server 2000
database and SQL 2005 database in the same report using SQL 2005 report
writing tools? If so, is there a recommended way to accomplish this. Any
tips would be much appreciated.

You can have multiple datasets from any data source you want. RS does not do
joins for you. So you need to either do this from a stored procedure using
linked tables (which in itself is problematic). If you need the equivalent
of joining data from two different databases then you should look at sub
reports.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]