Microsoft SQL Server Reporting Services
To be successful in today's competitive marketplace, organisations
must extend information beyond the walls of their company and
seamlessly interact with customers, partners, and suppliers in real
time. Microsoft SQL Server Reporting Services enables organisations
to transform valuable enterprise data into shared information for
insightful, timely decisions at a lower total cost of
ownership.
SQL Server Reporting Services is a comprehensive, server-based
solution that enables the creation, management, and delivery of
both traditional, paper-oriented reports and interactive, Web-based
reports. An integrated part of the Microsoft Business Intelligence
framework, Reporting Services combines the data management
capabilities of SQL Server and Microsoft Windows Server with
familiar and powerful Microsoft Office System applications to
deliver real-time information to support daily operations and drive
decisions.
Full Reporting Life Cycle Support
SQL Server Reporting Services supports the full reporting life
cycle, including:
- Report authoring. Report developers can create
reports to be published to a report server by using Microsoft or
other design tools that use Report Definition Language (RDL), an
XML-based industry standard used to define reports.
- Report management. Report definitions,
folders, and resources are published and managed as a Web service.
Managed reports can be executed either on demand or on a specified
schedule, and are cached for consistency and performance. New in
SQL Server 2005 Reporting Services, administrators can use SQL
Server Management Studio to organise reports and data sources,
schedule report execution and delivery, and track reporting
history.
- Report delivery. SQL Server Reporting Services
supports both on-demand (pull) and event-based (push) delivery of
reports. Users can view reports in a Web-based format or in
e-mail.
- Report security. SQL Server Reporting Services
implements a flexible, role-based security model to protect reports
and reporting resources. The product includes extensible interfaces
for integrating other security models as well.