Skip to content

Latest commit

 

History

History
63 lines (42 loc) · 3.2 KB

bind-a-report-or-model-to-a-shared-data-source-ssrs.md

File metadata and controls

63 lines (42 loc) · 3.2 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom helpviewer_keywords
Bind a Report to a Shared Data Source
Learn how to bind a report to a shared data source on a report server that is running in native mode or SharePoint integrated mode.
kfollis
kfollis
09/25/2024
reporting-services
report-data
how-to
updatefrequency5
shared data sources [Reporting Services]
data sources [Reporting Services], shared

Bind a Report to a Shared Data Source (SSRS)

In some situations, such as when you move a report 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 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, it will not work correctly when accessed from the new report server.

Important

Before rebinding a report 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 Create, Modify, and Delete Shared Data Sources (SSRS).

To bind a report to a shared data source on a report server running in native mode

  1. In the web portal, click the ellipsis (...) in the upper-right corner of the report tile > Manage.

  2. Click Data Sources.

  3. Click A shared data source, then navigate to the data source to which you want to bind the report.

  4. Select the data source and then click Save.

  5. Click Apply.

    The report is now bound to the data source that you selected.

To bind a report to a shared data source on a report server running in SharePoint integrated mode

  1. 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.

  2. Point to the report and click the down arrow.

  3. Click Manage Data Sources.

  4. Click dataSource1.

  5. In the Connection Type area, verify that Shared data source is selected.

  6. In the Data Source Link area, click the ellipsis (...) button.

  7. Locate the data source you want to use.

  8. Select the data source and click OK.

  9. Select OK.

  10. Click Close.

Related content