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