reporting Services Questions

What is Reporting Services?

Microsoft SQL Server Reporting Services is server-based reporting platform similar to Crystal reports, Brio which allow you to create tabular, matrix, graphical, and free-form reports from most of the databases.Reporting Services provides a complete set of services and tools. This comes with reporting portal which can be used to manage Reporting for creating, publishing and managing reports. Reporting Services supports databases that has .NET provider, OLE DB and ODBC. Reporting Services provides centralized report storage and management and Security.



What are the Reporting Services components..?

Report Designer:

Supports the report creation phase of the report lifecycle. It is an add-on tool for any edition of Visual Studio .NET 2003, suitable for both programmers and non-programmers.

Report Server:

Provides services for execution and distribution of reports.

Report Manager:

A Web-based administration tool for managing the Report Server.



Reporting service includes three core components
1. A set of tools that can be used to create, manage and view reports
2. A report server component that host and processes reports in veriety of formats.
3. An API that allows you to integrate or extend data and report processing in application, or to create custom tools to build or manage reports