Report Life Cycle: Creating, Managing, and Delivering Reports

This topic provides a high-level description of the report authoring, management, and delivery life cycle used in SQL Server Reporting Services.

Creating Reports

To create a report, you create a report definition file using Report Designer or Report Builder. The authoring tool to use depends on the requirements of the report and your level of expertise in report authoring techniques. Report Designer is a full-featured report authoring tool that runs in Business Intelligence Development Studio. Report Builder features a Microsoft Office-like authoring environment and new features such as new sparkline, data bar, and indicator data visualizations, the ability to save report items as report parts, a wizard for creating maps, aggregates of aggregates, and enhanced support for expressions, and runs as a separate client-side installation. For more information about Report Designer, see Report Designer. For more information about Report Builder, see What's New in Report Builder 3.0 in Report Builder 3.0 Help on msdn.microsoft.com.

You create reports on a client computer, separate from the report server. After your report looks the way you want, you can publish it to a report server or SharePoint site that is integrated with a report server, where it becomes available for general use, or you can save it to your local computer. To get started with your first report, see Tutorial: Creating a Basic Table Report (SSRS).

Managing Reports and Other Items

One of the principal advantages of using Reporting Services is the ability to manage reports and related items such as folders, data source connections, and resources, from a central location. You can define security, set properties, and schedule operations. You can also create shared schedules and shared data sources and make them available for general use. To manage reports and the reporting environment, use Report Manager. Report management includes the following tasks:

  • Organizing the reporting environment into folders to store collections of reports.

  • Enabling features such as My Reports, report history, and e-mail report delivery.

  • Securing access to folders and reports by assigning users and groups to roles.

  • Building shared schedules and shared data sources that you want to make available for general use.

Both users and report server administrators can manage reports, but in different ways. Users can publish and manage reports in a personal workspace named My Reports. Report server administrators can manage the entire report server folder namespace. The ability to perform management tasks depends on user permissions. For more information about administering a Reporting Services installation, see Administration (Reporting Services).

Accessing and Delivering Reports

In Reporting Services, two methods are available for accessing and delivering reports:

  • On-demand access allows users to select the reports from a report viewing tool. You can use Report Manager, a Microsoft SharePoint 2.0 Web part, a SharePoint library when Reporting Services is installed in SharePoint integrated mode, an embedded ReportViewer control, or a browser. For more information about on-demand access to reports, see Finding, Viewing, and Managing Reports (Report Builder 3.0 and SSRS).

  • Subscription-based access automatically generates and delivers reports to a destination. You can deliver reports to an e-mail inbox or a file share. For more information about subscriptions and delivery, see Subscription and Delivery (Reporting Services).

Reporting Services supports a variety of viewing formats. Reports at first display in HTML format, but after a report is rendered you can redisplay the report in a different format such as Excel or PDF. For more information about rendering reports in different formats, see Exporting Reports (Report Builder 3.0 and SSRS).