SQL Server Reporting Services
SQL Server Reporting Services (SSRS) is a SQL Server functionality that was introduced way back with the 2000 edition of SQL Server. SSRS 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. The integration between Configuration Manager and SSRS was first introduced in the 2007 version of Configuration Manager. For Configuration Manager 2012 and 2012 R2, SSRS is the only reporting option. SSRS has many features that give it advantages over other reporting tools. Here are the advantages of SSRS:
- It uses a standardized report system.
- SSRS report definition language (RDL) is stored in the XML format. This allows easy backup of the RDL files and easy migration between reporting servers.
- It has high performance, availability, and scalability.
- It allows you to build ad hoc reports...