How to: Bind a Report or Model to a Shared Data Source
New: 12 December 2006
In some situations, such as when you move a report or model from a test server to a production server, you might want to save the file to your local computer and then upload it to a different report server. When you upload the report or model to the new server, you need to rebind it to a shared data source that is stored on the new report server. If you don't rebind the report or model, it will not work correctly when accessed from the new report server.
Important
Before rebinding a report or model to a shared data source, the data source must already exist on the report server or SharePoint library. For more information about data sources, see Creating, Modifying, and Deleting Shared Data Sources.
To bind a report or model to a shared data source on a report server running in native mode
In Report Manager, click the name of the report or model that you uploaded to the server.
The Properties tab opens.
Click Data Sources.
Click Browse, and then navigate to the data source to which you want to bind the report or model.
Select the data source and then click OK.
Click Apply.
The report or model is now bound to the data source that you selected.
To bind a report or model to a shared data source on a report server running in SharePoint integrated mode
If the library is not already open, click its name on the Quick Launch bar. If the name of your library does not appear, click View All Site Content, and then click the name of your library.
Point to the report or model and click the down arrow.
Click Manage Data Sources.
Click dataSource1.
In the Connection Type area, verify that Shared data source is selected.
In the Data Source Link area, click the ellipsis (…) button.
Locate the data source you want to use.
Select the data source and click OK.
Click OK.
Click Close.
See Also
Tasks
How to: Upload a File or Report (Report Manager)
How to: Upload Documents to a SharePoint Library (SharePoint Integrated Mode)
How to: Create and Manage Shared Data Sources (SharePoint Integrated Mode)
How to: Create, Delete, or Modify a Shared Data Source (Report Manager)
Concepts
Creating a Report Model Project
Data Sources Supported by Reporting Services