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)

http://www.youtube.com/watch?v=gN3G094fJt0

 

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

http://www.microsoft.com/en-ie/download/details.aspx?id=29072

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

http://www.youtube.com/watch?v=00SX1XX3fl4

 

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

http://www.microsoft.com/en-us/download/details.aspx?id=39379