O'Reilly logo

Microsoft® SQL Server® 2008 Reporting Services Step by Step by Stacia Misner

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

Configuring Data Source Properties

You will likely design and test reports in BI Dev Studio by using a local data source that contains a representative subset of production data. By limiting the data used for report development, you can avoid long waits for report execution. On the server, however, you want reports to retrieve data from the production data sources. You can maintain one data source for your development environment and another for your server environment. The OverwriteDataSources property for the project controls whether the data source in your project gets copied to the server. By default, deployment copies the data source file the first time, but subsequent deployments ignore the data source file, allowing you to change the properties ...

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