Microsoft Office Tutorials and References
In Depth Information
easier access to reports generated by SQL Server Reporting Services. In other words, this
integration does not enable additional report features for SharePoint; it simply allows you to store,
edit, and view SQL Server reports (created initially using Report Builder, a separate product
meant to generate reports from data in databases in SQL) via the SharePoint library.
A new subsite
made from a
If you have a SQL Server instance running Reporting Services for SharePoint, you can
configure Reporting Services for SharePoint. This builds a new database that can run in SharePoint
Integrated mode. Fundamentally, this allows you to use SQL Server Reporting Services to store
reports in a SharePoint library, allowing direct access to the reports via the SharePoint interface.
Once the reports (and related content types) are in the library, they can be accessed by any users
with permission in SharePoint and can even be viewed directly using a Report Viewer web part
(also new to this version of SharePoint).
Reporting Services first needs to be set up on SQL Server 2008 R2 where a copy of SharePoint
has been installed and added to the SharePoint farm; then you need to configure the correct
URL, integration, and authentication settings in Central Administration, which will attach the
SharePoint farm to the reporting service (it will work only with SQL Server 2008 R2, not SQL
Server 2008). Once it’s connected, you can activate Reporting Services on any site in the farm.
Should you be interested in setting up SQL Server 2008 R2 with Reporting Services and you
want a handy way to store and access the reports generated, consider using this SQL Server
M A N A G I N G S H A R E D S C H E D U L E S
Shared schedules are used to run reports unattended. They’re typically first created on a report
directly (via the library where the report is stored). When a schedule is set as shared, it can then
be used by other reports (when configured to run unattended). Here you can see the currently