Monday, March 19, 2012

Can more than one database be queried

Can more than one database be queried when creating a report in SQL Server 2005 if they are from the same data source?

Our company is going to SQL Server 2005 for a bunch of Access databases and a C++ system. Would like to be able to query these different database at the same time to create the report. Is it possible to do this or do we need another reporting service?

Thank you for any help,

Jennifer

Yes, you can have multiple datasets based on one data source, or multiple datasets based on multiple data sources. See this page for more information on this http://msdn2.microsoft.com/en-us/library/ms160324.aspx

No comments:

Post a Comment