Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bgrantham
Starting Member
1 Post |
 Posted - 2006-01-03 : 17:30:09
|
| Hi,I hope someone can help. We are in the process of picking a new reporting tool/architecture. We are very interested in SQL Server Reporting Services 2005. The one question we have is can a single report work with multiple databases. As an example,If we have database1 and in it we have Table A, Table B, and Table C and want to move the tables to different DB's can we read them in one dataset as they are one. Our ending result might look like this.Database1 = Table ADatabase2 = Table BDatabase3 = Table CReport A sees DB1, DB2, DB3 as one dataset.Thanks for your help |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-03 : 17:36:32
|
| You can do that even in SQL Server 2000 by coding for it in the data set:SELECT ...FROM DB1.dbo.TableAUNION ALLSELECT ...FROM DB2.dbo.TableBUNION ALLSELECT ...FROM DB3.dbo.TableCTara Kizeraka tduggan |
 |
|
|
|
|
|
RSS 2005 Question