Microsoft Office Tutorials and References
In Depth Information
Now that Reporting Services and the Reporting Services Add-in are installed, you can configure your SharePoint
environment for Reporting Services by following the article at http://msdn.microsoft.com/en-us/library/jj219068.aspx .
To begin authoring reports, it is important to understand the features offered by the Reporting Services Add-in
and to choose the right mode (Local vs. Connected) for your reports. It is more likely that you will use connected
mode for enterprise reporting scenarios.
In previous versions of SQL Server, the Reporting Services Add-in was available as a standalone installer. But in
SQL Server 2012, this is bundled as part of the standard installation package. Let’s take a look at the features offered
by this add-in.
Reporting Services Add-in Features
This add-in brings the collaborative features of SharePoint into the reporting environment. Here are some key features
enabled by this add-in:
The Report Viewer Web Part, which can load and render report files.
Ability to create subscriptions and schedules, implement item-level security, and manage
reports, data sources, alerts, version control, and filters.
Publish reports using SSDT Report Designer to SharePoint libraries.
Open reports published to a document library using Report Builder.
Manage report server content using a Simple Object Access Protocol (SOAP) endpoint.
You can install the add-in either before or after the SharePoint product installation.
The steps you need to take to configure a report server are greatly reduced.
You can use SharePoint list data as a data source and generate reports from list data.
There is support for the SharePoint user token and claims-based authentication.
There is support for SharePoint Universal Logging Service.
You can run reports generated using Microsoft Access 2010 and Reporting Services SharePoint
list data extension in local mode.
There is support for multiple languages.
Provides support for Power View reports.
Reporting Services Local Mode vs. Connected Mode
In the context of SharePoint Server, Reporting Services can run in either connected mode or local mode. Connected
mode is the default and includes SharePoint Server, the SSRS add-in, and SQL Server report server. It enables
end-to-end reporting, collaboration, and server-based features such as subscriptions. However, after installing
the SSRS add-in, you have to configure your SharePoint server.
Local mode was introduced in the SQL 2008 R2 version; it is very lightweight and integrates Reporting Services
with SharePoint Server. It consists of SharePoint Server and the SSRS add-in, but it does not require a report server.
Because report server is not available, users can view the reports but they have no access to server-side features such
as subscriptions. In local mode, reports are rendered locally from a SharePoint document library. In order to run
local-mode reporting, you need to enable the ASP.NET session state.
When a user requests a report on the SharePoint site, the report server proxy endpoint creates a session and
connects to the report server. It prepares for the processing of the report, and on the report layout it delivers the data
and displays it using the Report View Web Part. There are other processing instructions that help in exporting the
report in the selected output format and providing drill-down capabilities, delivery on subscription, and so forth.
Search JabSto ::