Microsoft Business Intelligence – Reporting Services
Microsoft SQL Reporting Services Overview
To be successful in today's competitive marketplace, organisations must extend information beyond the walls of their organisation 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.
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 email.
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.
To discuss your Microsoft Business Intelligence requirements in more detail, please call us on 0845 850 1550 or email us at sales@pythagoras.co.uk.