I’ve been working a side-project that involves tying in SharePoint with Reporting Services. One of my wise co-workers managed to point some of the benefits and constraints that Microsoft has found in using the Reporting Services add-in for SharePoint.
Configuring a report server to run in SharePoint integrated mode provides the following additional functionality that is only available when you deploy a report server in this mode:
- Use document management and collaboration features, including alerts and version control. A SharePoint site provides a unified portal for accessing and managing all documents in one place.
- Use SharePoint permissions and authentication providers to control access to reports, models, and other items.
- Use SharePoint deployment topologies to distribute reports over an Internet connection outside the firewall. A report server provides report and data processing services in the context of a larger SharePoint deployment that is configured for Internet access.
- Manage reports, models, data sources, schedules, and report history in custom application pages on a SharePoint site. You can set properties, define schedules and subscriptions, and create and manage report history on a SharePoint site the same way you create and manage them from other tools in SQL Server.
- View a report in a new customizable Report Viewer Web Part. The Web Part includes page navigation, search, print, and export features.
- Publish or upload reports, report models, resources, and shared data source files to a SharePoint library, including Report Center in Office SharePoint Server.
- Use Report Designer, Model Designer, and Report Builder to create report server items. If you are using the Service Pack 2 version of these tools and if you configure the report server to run in SharePoint integrated mode, you can publish the newly created items directly to a SharePoint library. You can also use the Upload action on a SharePoint site to add any report definitions and report models to a SharePoint library.
- Because the report server processes report definitions in the same way regardless of the server mode you use, the report data and layout is unaffected by server mode. Any report that you can run in a native mode report server can run on a report server that is configured for SharePoint integrated mode.
- Create ad hoc reports using report models and Report Builder. You can generate models and start Report Builder from a SharePoint site. You can add, open, and save ad hoc reports to a SharePoint site. If you are using the Enterprise Edition, you can deploy ad hoc reports that support infinite clickthrough functionality.
- Subscribe to and deliver reports to a SharePoint library using a new SharePoint delivery extension. You can also deliver reports through e-mail or to a shared folder. The report server delivery extensions are used to deliver reports.
- In Office SharePoint Server , connect a Report Viewer Web Part to a Filter Web Part or a Library Web Part in dashboards or Web Part pages.
- Program against a new SOAP endpoint to create custom applications that integrate with a SharePoint site. You can also use the updated Windows Management Instrumentation (WMI) provider to programmatically configure a report server instance that runs in SharePoint integrated mode.
Unsupported SharePoint FeaturesUnsupported SharePoint Features
- Not all features are available for integrated operations. On the SharePoint site, you cannot use SharePoint Outlook calendar integration or SharePoint scheduling for report server document files. Personalization is also not supported.
- Unsupported Reporting Services FeaturesUnsupported Reporting Services Features
The following features are not available on a report server that runs in SharePoint integrated mode:
- URL addressing is different in SharePoint integrated mode. SharePoint URLs are used to reference reports, report models, shared data sources, and resources. The report server folder hierarchy is not used.
- Reporting Services custom security extensions cannot be deployed or used on the report server. The report server includes a special-purpose security extension that is used whenever you configure a report server to run in SharePoint integrated mode. This security extension is an internal component, and it is required for integrated operations.
- Report Manager or Management Studio cannot be used to manage a report server instance that is configured for SharePoint integration.
- Data-driven subscriptions are not available. This applies to all editions.
- The rs.exe command line utility is not supported. The utility does not support the SOAP endpoint used for programmatic access to a report server that runs in SharePoint integrated mode.
- Linked reports are not supported.
- My Reports is not supported.
- Job management features that allow you to stop a long-running report process are not supported.
- Batching methods will not be supported.