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)
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.
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
a) Server Infrastructure for process memory monitoring
b) Reporting Processing uses a file system caches t adapter to memory pressure
c) Administrator is able to set targets (min, Max)
d) Adapts to other processes consuming memory.
a) Report processing
a) Reports in SQL: 2005 are memory bound
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
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
It is the heart of reporting services which is implemented as windows server.
It consists of
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
Report server has 2 cool processors
a) Report processor
b) Scheduling and delivering processor
Report server back end:
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:-
Get Updates on Tech posts, Interview & Certification questions and training schedules