Tuesday 17 June 2014

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.
  • You can download some samples from here.
  • Next, lets look at how to install SSRS and get you started.

No comments:

Post a Comment

SQL/SSRS Interview questions I thought of blogging some SQL/SSRS interview questions.

Below are some. I will add more, when I complete the compilation 1. What is OLTP(Online Transaction Processing)? OLTP stands ...