Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Linked servers used in Report Builder 3.0 Expand / Collapse
Author
Message
Posted Tuesday, November 12, 2013 8:22 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:16 AM
Points: 117, Visits: 177
I hope I'm in the right place. I am using Report Builder 3.0. I think it is basically the same as SSRS so, if not can you point me in the right direction. I need to report on data from databases on different servers. Can this be accomplished in Report Builder?
Post #1513482
Posted Tuesday, November 12, 2013 10:32 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 5:58 AM
Points: 75, Visits: 624
Yes. You can define a data source and select from the drop-down providers, including ODBC, and connect directly.
If you are using linked servers just create a datasource to your database and write the query in the query box using the qualified name, OPENQUERY etc.
Post #1513556
Posted Tuesday, November 12, 2013 10:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:16 AM
Points: 117, Visits: 177
Wonderful. Thanx.
Post #1513557
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse