Microsoft Office Tutorials and References
In Depth Information
Introduction to Reporting Services
Reporting Services is a server-based platform that facilitates reporting with ready-to-use tools to author, manage,
deploy, and deliver reports using Web or Windows applications. Using Reporting Services, you can retrieve data from
various data sources, publish reports, and view or export them in various formats. Reporting Services also includes a
central management capability through which you can manage reports and report security.
Reporting Services delivers end-to-end processing and management of reports, with solutions that address a
wide range of scenarios. You can take advantage of the out-of-the-box features using built-in tools or write custom
code using the API. In this way, the product meets the needs of different audiences—report administrators, report
authors, and business users. Although they all essentially share same tools, the Reporting Services API helps
developers extend the features and functionality.
Here are some of the key features of Reporting Services:
Builds reports from a range of data sources
Creates a variety of reports, (including tabular, matrix, and charts) to meet different needs
(such as column-based, with summarized data, with graphical data, and more) using
Supports ad hoc reporting with report templates using a ClickOnce application called
Lets users create reports, save them locally, publish them to a SharePoint site or Report Server,
and subscribe to these reports
Supports interactivity, drill-down, and linking to subreports
Supports eight presentation formats—HTML, MHTML, PDF, XML, CSV, TIFF, Word, and
Excel—to open or export a report
Allows embedding custom or third-party controls with custom report extension(s) in reports
Allows adding bookmarks and document maps in large reports
Aggregates and summarizes data using controls and expressions
Supports embedding images and external content
Now let’s take a look at the Reporting Services architecture.
The Reporting Services architecture consists of three major components:
• Report Manager: This is the front end of Report Services, the UI that provides access to the
Reporting Services web service, which in turn connects to the Report Server database.
• Web Service Components: These components handle and process all on-demand and
interactive requests from report manager and the other tools. They act as a programmatic
interface for any custom development and interact with background processing applications.
• Background Processing Applications: These are Windows service components that process
reports triggered from a schedule and deliver them based on processing extensions. There are
several processing extensions to support different operations:
• Security extensions handle authentication and authorization of users and groups.
While the default security extension is Windows authentication, you can write a
custom authentication model and replace the default.
Search JabSto ::