Database Reference
In-Depth Information
From a feature perspective, there are only a few differences between Native
and SharePoint Integrated mode. For example, Data Alerts are only available
in SharePoint Integrated mode, while My Reports and Linked Reports are only
available in Native mode. Each of these features will be discussed in more detail
later in the chapter.
Both modes provide mechanisms for scaling out to accommodate a growing user
load. See the following TechNet articles for details
http://technet.microsoft.
com/en-us/library/hh479774.aspx
and
http://technet.microsoft.com/en-
us/library/ms159114.aspx
.
Scheduling
When it comes to standard reporting in general, the ability to schedule reports has
become a ubiquitous feature in nearly all enterprise-level solutions; SQL Server
Reporting Services is no exception. In the context of Reporting Services, a schedule
is simply a request to automatically run a report at some point in the future. While a
schedule is most commonly configured to execute on a regular, recurring basis, it can
also be configured to execute a report just once and never again.
Reports can be associated with multiple schedules. For example, a report might be
configured to run every weekday at 8 am (schedule 1) as well as every Sunday night
at 10 pm (schedule 2).
Scheduling is available in both SharePoint Integrated and Native modes and comes
in two forms: custom and shared. A custom schedule is a schedule created for a
specific report and cannot be used by other reports on the report server. A shared
schedule is a standalone, server-level object defined by a power user or administrator
and can be used by multiple reports on the report server.
One major requirement associated with scheduling is that the report must
be configured to use either stored credentials or no credentials. Windows
integrated security is not an option since the schedule is not associated
with a user account, which can cause problems when trying to deal with
dynamic data security.
The following screenshot shows the interface for creating a schedule on a
report server installed in Native mode. The interface is similar in SharePoint
Integrated mode:
