SQL Server Reporting Services

SQL Server Reporting Services provides a server-based platform, designed to support a wide variety of reporting needs, including managed enterprise reporting, special purpose reporting, embedded reporting, and web based reporting. SQL reporting services provides wide range of tools and

services to help us to create, deploy, manage and deliver reports as well as programming features that enable us to extend and customize reporting functionality.

SQL Server Reporting

SQL Server Reporting Services (SSRS) Features
SQL Server Reporting Servicess / SQL Reporting Services is a enterprise level reporting system, capable of generating complex reports. We use the capabilities built into it to deliver the varied needs of our clients. With SSRS we can create the following types of reports:

Parameterized Reports

Linked Reports

Snapshot Reports

Cached Reports

Ad hoc Reports

Clickthrough Reports

Drilldown Reports

Drillthrough reports

Subreports

SQL Server Reporting Services (SSRS) System

Integrating SQL Server Reporting Services/SQL Reporting Services into an application is for managing all the reporting needs. It can also be used to integrate SSRS into an existing application to meet their reporting needs. Apart from being able to create a new system for an existing application, we need to have the ability to support and enhance/upgrade existing SQL Reporting tools.

SQL Server Reporting Services (SSRS) Industries

SQL Reporting Services is the primary choice where the reporting needs are exhaustive. Again the needs vary depending on the industry to which the core application caters too. We have done extensive reporting for some of these industries:

Health-Care Industry

Insurance Group industry

Logistics Industry

Oil & Gas Industry

Food & Beverages industry

University / School Sports Websites

SSRS components include:

Report Server - the report processing engine and databases
Report Designer - the main report design environment, which runs in SQL Server's Visual Studio shell Business Intelligence Development Studio (BIDS)
Report Manager - a web-based interface used to manage reports, security, subscriptions, data sources, and more
Other components for administration, and other functionality

In the next post I will demonstrate how to create a new SSRS project, a shared data source, and a
report based on the database.