1275
Chapter 56: Confi guring and Administering Reporting Services
56
- Click the arrow next to the item, and from the drop-down menu, select Security.
- If the item still inherits its security settings from its parent, click the Edit Item
Security button. An alert displays indicating that the security is inherited, and
that if you continue to edit the item’s security, you will break the inheritance.
Select OK to continue. You can also delete roles that were assigned to the parent. - Click the New Role Assignment button.
- Enter the group or username, for example, myDomain\accounting.
- Select one or more roles to assign to the group or user.
- Click OK to save the new role assignment.
Remember that for users to access an item-level resource, they must also be granted
system-level access. (See the previous section “Granting System Access to Users and Groups.”)In addition, modifying an item’s security automatically applies the security to all child
items that inherit that security. To restore the inherited security for an item that has been
customized, click the Revert to Parent Security button. An alert displays prompting for
confi rmation before the security settings defi ned for that item are replaced by the security
settings of its parent.Managing Subscriptions
The capability to subscribe to reports represents an extremely valuable feature in Reporting
Services to automate report delivery. Reporting Services supports both push-and-pull para-
digms for report delivery. For example, upon scheduled report execution, a subscription can
send an e-mail with an attachment containing the report content (push), with the report
content in the body of the e-mail (push), or with a link to the report stored on the report
server (pull). Alternatively, reports can be written to a fi le share or to SharePoint libraries
where users or other systems can access the report or exported data.Report subscriptions require that the SQL Server Agent service runs on the relational data-
base hosting the ReportServer database. This service executes jobs, monitors SQL Server,
fi res alerts, and allows automation of some administrative tasks for the report server.
Before creating a subscription, ensure that this service is started. In addition, to success-
fully creating a report subscription, the connection credentials for the report data source
must be stored. For example, setting a data source to connect using user credentials does
not work for reports running as subscriptions because there is no interactive user at the
time the subscription runs.To begin creating a subscription, select the report you want to subscribe to, and click the
New Subscription button in the report control header. Figure 56-9 shows the options avail-
able for a fi le share subscription. You can confi gure options for report delivery, subscription
processing and scheduling, and the report parameter values. More information about each
of these options is detailed in the next section, which describes how to create data-driven
subscriptions, which enables these options to be set using the results from a query.c56.indd 1275c56.indd 1275 7/31/2012 10:34:19 AM7/31/2012 10:34:19 AM
http://www.it-ebooks.info