SQL Server Reporting Services (SSRS) : An Overview

Microsoft SQL Server Reporting Services (SSRS) is a server based reporting platform. It provides reporting functionality from a different data sources. It provides a set of tools to create, test, manage and deploy reports. It also provides APIs which gives developers to integrate / extend data and processing the report in custom application.

You can do following things with Reporting services:

·         Create interactive, tabular, graphical or free-form reports from different data sources.

·         Publish and schedule report processing.

·         Create Ad-hoc report based on predefined models.

·         Different viewing formats for a report.

·         Export reports to other applications.

You can view reports created through Reporting services over a web-based, windows application or SharePoint sites.

As days progresses I will write how things will work for SSRS. I will be using SQL SERVER 2008. The following are outlines which I will follow

·         What are Reporting Services Components?

·         How to Install Reporting Services?

·         What is Business Intelligence Development Studio (BIDS)?

·         How to create a Simple Report with the Wizard?

·         How to create a Simple Report with the Report Designer?

·         How to deploy Reports?