SQL Server Reporting Services (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.
- 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.
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
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
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
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
- Data base maintenance
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
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
Simple SSRS Architecture:
Enroll for Live Instructor Led Online MSBI Training