Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

How to: Publish a Shared Data Source to a SharePoint Library from Report Designer (SharePoint Integrated Mode)

New: 12 December 2006

To publish a shared data source to a report server running in SharePoint integrated mode, you need to set the report project properties in Report Designer. For a report server running in SharePoint integrated mode, all references to shared data sources, servers, reports, and resources must be fully qualified URLs.

You must have Member or Owner permission on the SharePoint site.

  1. In SQL Server Business Intelligence Development Studio, open your existing or new Report Server project.

  2. From the Project menu, click Properties. The <project> Property Pages dialog box opens.

  3. Choose the Configuration you use to publish to a SharePoint site. For example, Active(Debug) or Production.

  4. In the Deployment section, set the optional TargetDataSourceFolder, type a URL to a library or library folder. For example, http://TestServer/TestSite/Documents/DataSources.

    If left blank, this defaults to the TargetReportFolder value.

  5. For TargetReportFolder, type a URL to a library or library folder. For example, http://TestServer/TestSite/Documents.

  6. For TargetServerURL, type a URL to a SharePoint top-level site or subsite. If you do not specify a site, the default top-level site is used. For example, http://servername, http://servername/site or http://servername/site/subsite.

  7. Click OK.

  8. In Solution Explorer, right-click on the shared data source you want to publish, and click Deploy. The data source is published to the location specified in TargetDataSourceFolder. Deployment errors appear in the Output window.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft