O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Shared Data Sources

Unless you use shared data sources, the data source for your report is embedded into its RDL. This means that when you want to change that data source, you must modify the report or, at the very least, change its data source properties using Report Manager. If you don’t use shared data sources, each of your reports requires its own data source, and these data sources cannot be used by any other report.

It’s truly a best practice to use shared data sources. When the time comes to make a connection change, you have to look in only one place. Think of how useful (and timesaving) this will be when you need to test your reports in a development environment and then run them against production. When using SQL Reporting on ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required