Home » BI Tools » Reporting Services » Managing SSRS Reports

Managing SSRS Reports

Managing SSRS Reports:
The report author publishes the report to a central location where it can be managed by a report administrator in terms of security and delivery. This central location is an SSRS database. After the report is published, the administrator can use Report Manager, SharePoint, custom written scripts, third-party tools, or SQL Server Management Studio to manage published reports. The report administrator can

•Assign the report’s security or the right a user might have to a report.
•Establish execution control, such as selecting a time of an execution or caching options.
•Access and organize subscriptions from a single location.
•Control report-execution properties, which control how and when reports are processed. For example, the administrator can set processing options to prevent a large report from running on demand.
•Set timeout values to prevent a single report from overloading system resources.
•Automate report delivery through a standard subscription. Users can use subscriptions to set report presentation preferences. Users who prefer to view a report in Excel, for example, can specify that format in a subscription.
•Automate report distribution through data-driven subscriptions. A data-driven subscription generates a recipient list and delivery instructions at runtime from an external data source. A data-driven subscription uses a query and column-mapping information to customize report output for a large number of users.
•Set delivery methods for a report, such as file share, printer (this would require a custom extension in the current release, which is discussed in Chapter 29, “Extending Reporting Services”), or email.

Report Manager.
The default URL for Report Manager is http://server_name/reports as shown below. This is a default virtual directory in which Report Manager is installed. A report administrator can later change this URL by editing configuration files or using the Reporting Services Configuration Manager.

Reporting Services Configuration Manager.

Using SQL Server Management Studio an administrator can perform most of the operations that she would otherwise perform through Report Manager. SQL Server Management Studio can access the SSRS catalog directly and does not require the SSRS Windows Service to be running to change the report’s properties. However, an administrator will not be able to view the report if the SSRS Windows Service is not running.

Managing within SQL Server Management Studio is shown below.

Leave a Reply

Your email address will not be published. Required fields are marked *