I need to create a report that will need to run against 2 different instances of sql server (schemas are the same, data is different). How do I approach this so I only have to maintain one report? To be honest, I'm a bit confused by the Embedded Connection vs. the Use Shared Data Source Reference in the Data Source Properties window.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.