What is SSRS? SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It is part of suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services). SQL Server Reporting Services provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization. Reporting Services includes programming features that enable you to extend and customize your reporting functionality. Reporting Services is a server-based reporting platform that provides comprehensive reporting functionality for a variety of data sources. Reporting Services includes a complete set of tools for you to create, manage, and deliver reports, and APIs that enable developers to integrate or extend data and report processing in custom applications. Reporting Services tools work within the Microsoft Visual Studio environment and are fully integrated with SQL Server tools and components. SSRS or SQL server Reporting Services which is also called Microsoft SQL reporting, is a component of the Microsoft BI stack. The Microsoft Business Intelligence Stack mainly consists of SQL Database Engine, SSRS, SSAS, SSIS and other tools SSRS is a set of readymade tools, that helps you to create, deploy and manage reports. You can extend reporting functionality using C# and VB as programming languages. Microsoft SSRS or Business Intelligence SSRS, lets you create very rich reports (Tabular/Graphical/Interactive/free-form) from various datasources with rich data visualization (Charts, Maps, sparklines). All these reports can be viewed via a web browsers. SSRS allows are reports to be exported in various formats (Excel, PDF, word etc) SSRS allows reports to be delivered via emails or dropped to a share location in an automated fashion. SSRS provides a host of security features, in order to control, who sees which reports etc. You can download some samples from here. Next, lets look at how to install SSRS and get you started.

Share this

Related Posts