[Microsoft BI] SSRS

 

 What is SSRS 

• 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.