SQL Server Reporting Services

Microsoft’s SQL database was designed to house vast amounts of Data, irrespective of the type of database be it relational or a data warehouse. The Information stored in a database is vital to the way businesses run in today’s information centric world. However, equally important is the ability to traverse that information and present it in a highly usable way. SharePoint SQL Reporting Services is just such a presentation tool. It provides a powerful report builder and uses SharePoint Document Libraries for storing reports where SharePoint Security governs and manages authorisation.

Coupling SSRS with SQL integration Services and SQL Analytical Services, provides an outstanding presentation layer for information housed in almost any type of database. Its integration with SharePoint is so seamless that access to these reports will become second nature to SharePoint users.  SSRS reports have advances features like the ability to  drill down through collapsed content, link to other reports, master - child sections, gauges, graphs, indicators, ability to be converted to Excel and PDFs and ability to be scheduled for auto execution.