Mindmajix

SQL Server Reporting Services (SSRS) Overview

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

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.

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 

1) IIS REMOVED IN 2008

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

  • SAL OS
  • SQL CLR
  • SQL NETWORK INTERFACE
  • COMMUNICATIONS THROUGH http.SIS protocol

2) RICH MEMORY MANAGEMENT ADDED

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.

3) RS 2008 REPORT ENGING CHANGES

a) Report processing

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

b) Rendering

  • New rendering architecture
  • Renderer rewrites

4) SCALABILITY

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.

5) DUNDAS ACQUISTION

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)

6) TABLIX – NEW DATA REGION

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

Screenshot_117

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

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:

ssrs-architecture

Enroll for Live Instructor Led Online MSBI Training


0 Responses on SQL Server Reporting Services (SSRS) Overview"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.