Conventional Reports provide details

To be successful in today's competitive marketplace, organizations need to extend information beyond the walls of their organization and seamlessly interact with customers, partners, and suppliers in real time. Microsoft SQL Server Reporting Services enables organizations 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.

InfoTrove can build upon the Reporting Services Architecture for your organization to seamlessly integrate with your Business Intelligence Portal. Executive Management and Knowledge workers can view reports based on their security privileges and access rights. Reports have in-built drill down capabilities connected to the OLAP.

An Integrated Architecture

SQL Server Reporting Services supports a wide range of common data sources, such as OLE DB and Open Database Connectivity (ODBC), as well as multiple output formats such as familiar Web browsers and Microsoft Office System applications. Using Microsoft Visual Studio® .NET and the Microsoft .NET Framework, developers can leverage the capabilities of their existing information systems and connect to custom data sources, produce additional output formats, and deliver to a variety of devices.

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 the Report Server using Microsoft or third-party 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.
  • 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.


Reporting Services - Key Features.

Reporting Services uses data processing extensions to retrieve data for reports. Reporting Services can retrieve data from the following:

  • SQL Server relational databases
  • SQL Server Analysis Services cubes
  • Oracle
  • Open Database Connectivity (ODBC) data sources
  • OLE DB data sources
Rendering Because report rendering is separate from the initial processing of the report data, the same report may be rendered in different formats through the use of rendering extensions. Reporting Services includes the following rendering extensions:
  • HTML
  • HTML With Office Web Components
  • Multipart HTML
  • Microsoft Excel
  • Image / TIFF
  • PDF
  • Comma-separated variables
  • XML
Delivery extensions are responsible for delivering rendered reports on a schedule or other event to various locations. Reporting Services includes the following delivery extensions:
  • E-mail
  • File system