SQL Server reporting services (SSRS)

SQL Server reporting services (SSRS) is a suite of tools made available by Microsoft as an alternative to Crystal Reports and as an optional component of SQL server. Reports are created using a Visual Studio component or other Client Report Definition (RDLC) designer such as Report Builder. Reports are published to a central store to be viewed, manipulated and exported to a variety of formats. SSRS needs to be enabled and configured before reports can be published to its report hosting web application.


The following resources should give a good overview and starting point for anyone planning on building RDLC Reports

SQL Server Reporting Services Overview (4:57)



SQL 2012 Report Builder -> for designing and publishing reports -> uses the familiar MS Office interface.


SQL 2012 Report Builder Tutorial -> (11:59)



There is also an addin available for Excel called “Power Query” that allows for the easy aggregation of basic data from SQL, a user can then use the Excel components that they are already familiar with to create reports.

Power Query > Excel Addin for creating Excel reports