SQL Server Reporting Services (SSRS) is a server-based scalable and Extensible platform for authoring, deploying, executing and managing Reports based on a variety of data sources.
It is also called Microsoft SQL reporting & is a component of the Microsoft BI stacks. SSRS is a set tool that helps you to create
Install and manage reports. You can develop functionality using C
language by using Business Intelligence SSRS to create great
Report from different data marts.
SSRS installation:
Both database and SQL server Reporting will install in a Native mode when running
SSRS server. To install both services at one time, depending upon choosing of the
Installation process configures the SSRS services for you. If SSRS is Installed
later, you have to configure it
Selecting features for installation purpose:
1. Database Engine
2. SQL Server Reporting Services Native
3. Management Tools – Basic
4. Management Tools – Complete
5. Business Intelligence Development Tools or SQL Server Data Tools
If available with the media you are using, which is dependent on The version
SSRS Architecture:
These types of articles are focused on the development of reports. SSRS Can
deploy to SharePoint, but this series of article only Covers the native deployment
architecture SSRS placement must associate with a SQL Server instance.
On The instances are two types of databases:
1. Report Server: Contains the report definitions, configuration,
History, security of deployed reports and more
2. ReportServerTempdb: Much like temp DB, it used as a workspace
For building reports and doesn’t maintain any objects.
We will also need a location for the Report Server Web Service, which
Can be on the same database, on whatever server we choose, we have access
To a report manager website that allows us to deploy and manage the reports.
The fig. shows the architecture of SSRS.
SSRS Development tools:
The latest version of SQL server used Business Intelligence Development Studio (BIDS).
Yet start the first server in 2012. You will use SQL Server Data Tools – Business
Intelligence. Which may be on the SQL Server media, depending On the version. Every
tool runs as an add-in for Visual Studio.
The following table should help you navigate the options, understand the variation,
And find correct process for installing development tool for your version of SQL Server.
1. SQL server version: 2008 R2
Development Tool: BIDS
Location of Media: SQL Server installation media
Documentation: http://technet.microsoft.com/en-us/library/bb522791 (v=sql.105).asp.
2. SQL server version: 2012 option 1
Development Tool: SSDT-BI and VS 2010
Location of Media: SQL Server Installation media
Documentation: http://msdn.microsoft.com/en-us/library/ms143711 (v=sql.110).asp
3. SQL server version: 2012 option 2
Development Tool: SSDT-BI and VS2012
Location of Media: Download here http://www.microsoft.com/en-us/download/details.aspx?id=36
Documentation: http://msdn.microsoft.com/en-us/library/ms143711 (v=sql.110).asp
SSRS Configuration:
If you were unable to installation process configure SSRS for you, or are installing
SSRS after the initial engine installation or you decided to configure SSRS on your
Own for fun, you will launch the Reporting Services Configuration Manager.
As discussed, we associate SSRS with a SQL Server instance, where it can create the
Reporting databases, when prompted, select the instance, Name and click Connect.
Advantages of Reporting service (SSRS):
1. Direct and efficient reporting access to information in both Oracle and MS SQL Server database...
2. Faster production of reports on both relational and cube data.
3. An easy to deploy centralized reporting infrastructure based on Microsoft Reporting Services.
4. Faster delivery of information to the business, providing better decision support.
5. No need for expensive specialist skills.
6. The security managed in a role-based manner and can apply to folders as well as reports.