SQL Server Reporting Services (SSRS) Overview

  • (4.0)
  •   |   738 Ratings

SSRS Overview

Reports are required in general but situations
a) For Internal Reports
b) For external Reports
Internal Reports: Generally, company Internal Operations such as pay slip, salary slip, Relieving letter, Internal Audition etc.
External Reports: This reports generally submitted to 3rd party authorities such as IT department, STPI etc…
Conclusion: To create this type of reports we go for different reporting applications like cog Nos, BO, SSRS, CRYSTAL REPORTS, MICROSTAR tegy etc

Related Page: What Is SSRS (SQL Server Reporting Services)

Report Usage Types

1) Standard Reporting: Here there will be a centralized database. Multiple users connect to database and they generate the own reports
2) Adhoc Reporting: This report also can be called as dynamic reports and the content and layout changed every time.
3) Embedded Reporting: Here the reports are embedded with the 3rd party applications like Java, net etc.

Learn how to use MSBI, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Enroll for Free MSBI Training Demo!

Enterprise Reporting Life Cycle

There are 3 phases
a) Authering: Here design, identify, content, placed, layout specification
b) Managing Phase: Once the report is generated security and the manageable operations for the report applied here
c) Access and Delivery Phase: In this phase report publishing, accessing … etc taken place.

SSRS Additional Features 


As there is a conflict to other applications they removed the dependency of IIS in 2008 by replacing with the components

  • SAL OS


a) Server Infrastructure for process memory monitoring

  • Dynamic, sel 7 – managing with Memory pressure
  • Reduces through put in memory pressure situations

b) Reporting Processing uses a file system caches t adapter to memory pressure

  • Receives memory events from server

c) Administrator is able to set targets (min, Max)

  • Minimum threshold defines the amount of memory the server thinks ‘belongs’ to it
  • The memory is only used if a requests need it.
  • Maximum threshold defines that not to exceed value.

d) Adapts to other processes consuming memory.


a) Report processing

  • On – demand processing
  • Hierarchical cursor – based object model.

b) Rendering

  • New rendering architecture
  • Renderer rewrites


a) Reports in SQL: 2005 are memory bound

  • Memory usages is proportional to data size.
  • Large datasets can cause out of memory exceptions
  • Memory usage in problem renderers (pdf. Excel, csv)

b) Very large reports can starve (or) fail many smaller reports.


a) The SQL SERVER reporting services team has acquired dunda’s software data visualization products.
b) Chart, guage,  map, barcode and calendar for reporting
c) Chart, guage for share point
d) Chart program / enterprise, guage, map, OLA P chart and tab controls for visual studio (windows and web)


a) Tablix provides a combination of the best features of tables and matrix data regions
b) Build versatile reports
c) Allows a flexible layout with multiple Row and column

Related Page: SQL Server 2008 R2 – LookUp Enhancement In SSRS

HTTP Listener
It monitors the incoming request directed to HTTP.sis on a specific code on the local computer the host name and port are specified on a URL resection while you configure the server.
When the HTTP listener process the request it forwards the application layer to verify the user ident

Authentication Layer:
It verifies the user id, password (Or) the identity of user (or) application that makes the request. The following authentication that supported are
Windows Integrated security

  • NTLM Authentication
  • Forms Authentication
  • Basic Authentication
  • Anonymous Access

Report Server
It is the heart of reporting services which is implemented as windows server.
It consists of

  • Windows service
  • Report manager
  • Web service
  • Back ground processing

a) Windows Service: (provides report scheduling & delivery services):-
Both the services are used in designing, saving, executing, managing and publishing the reports Reporting services hosts the report manager, the reports report server, web service & background features in their own service.
b) Report Manager: It provides client fronted access the report server Items and their management
c) Web service: It provides access to report server via report builder.
d) Back ground processing: There are many processing have in this background processing

  • Reporting Processing
  • Data processing
  • Model processing
  • Data Rendering
  • Data authentication extensions
  • Scheduling
  • Subscription
  • Data base maintenance

Frequently Asked MSBI Interview Questions & Answers

Report processing:

Report server has 2 cool processors
a) Report processor
b) Scheduling and delivering processor

Report server back end:

  • Report server stores folders and files just like file system.
  • The Report you create exists as a file in the files with extension “.RDC” (Report definition language).
  • When the report is published it will be stored in the report server database
  • The deployment uses a2SQL server relational data bases for internal storage

Report server temp db à It stores temporary data session information and caching information

Data processing:

It is designed to retrieve a specific type of data source and provide extended functionality during report design and processing.

Data Rendering extensions:-
There are three rendering formats available
a) Data render:  Data only display
Eg:– CST & XML
b) Soft page break render :- Maintain format & layout
EG:– Msword, excel, MHTML, Report viewer controls etc
c) Hard page break render:-  It supports gif & pdf formats

Scheduling Delivery Extensions:-

  • Report server Email
  • Report server file share.
  • Custom extensions
  • Subscriptions

Simple SSRS Architecture:


Explore MSBI Sample Resumes! Download & Edit, Get Noticed by Top Employers!Download Now!

List of Related Microsoft Certification Courses:

 SSIS  Power BI
 SSAS  SQL Server
 SharePoint  BizTalk Server
 Team Foundation Server  BizTalk Server Administrator


Popular Courses in 2018

Get Updates on Tech posts, Interview & Certification questions and training schedules