SSRS
Need of SSRS
SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft that allows you to produce formatted reports with tables in the form of data, graph, images, and charts. These reports are hosted on a server that can be executed any time using parameters defined by the users. It is part of Microsoft SQL Server Services suite.
Different Types of reporting services
Three types of SSRS reporting services are:
→ Microsoft SQL Server Integration services which integrate data from different sources
→ Microsoft SQL Server Analytical service which helps for the analysis of the data
→ Microsoft SQL Server Reporting service allows for generating a visual report of the data
Reasons To Use SSRS:
→ Easy to deploy : whereby reports are stored on a centralized web server. Because reports are centralized, users can run reports from one place and having centralized reports also means that report deployment is quite simple
→ Decision Making : It gives Good and more accurate Decision-making mechanism for the users
→ Ability to develop a Reporting Portal - Enables organizations to embed reports directly into business applications and web portals, enabling users to consume reports within the context of their business process. Organizations are able to bring all business critical data, structured as well as unstructured, from across the company
→ Make a report run based on your timing via Report Subscription – SSRS supports standard as well as data-driven subscriptions, enabling the automatic delivery of reports to the right users by pushing them directly to
→ each user via email or by sending them to a file share from where users can pull the reports. Users can use standard subscriptions to have reports delivered to them based on a custom schedule and specified report parameter values
→ Interactive sorting capabilities - Applying sort capabilities to a report enables users to sort the data by any of the columns of the report in ascending or descending order. For example, a user viewing a report containing a list of sales might sort the data first by date, and then by sales amount
→ Drilldown reporting - Without any customization or programming,
Users can seamlessly drill through any combination of data in the database
→ Easy export for further analysis with multiple file formats - Users need to be able to access and share reports in the format with which they are most familiar. SSRS supports rendering to most common file formats including HTML, PDF, CSV, XML, and Image (TIFF) and also offers complete rendering in Microsoft Office Word and Microsoft Office Excel
→ SSRS provides a host of security features, which helps you to control, who can access which report
Features of SSRS
Offers a Simple Object Access Protocol (SOAP) application and pluggable architecture
Retrieve data from managed, OLE ODBC, and DB connections
Allows you to create adhoc reports and save them to the server
Display data in a variety of formats which includes tabular, free-form, and charts
Create custom controls by using report-processing extension
Embed graphics, images to the reports. You can also integrate with external content using SharePoint
You can store and manage custom reports
Chart and Gauge control feature allows you to display KPI data
Comments
Post a Comment