Report Development with SQL Server Reporting Services (SSRS)

With SQL Server Reporting Services (SSRS), you can create Web-enabled reporting. Your reports can retrieve data from a variety of data sources, and such reports can be published in various formats. Reporting Services can be installed when installing SQL Server (2008 R2, 2012, 2014, 2016) Developer, Standard and Enterprise Editions. SQL Server (2008 R2, 2012, 2014, 2016) Express Edition includes a limited version of Reporting Services.

There are two steps you must do prior to using SSRS for report development:

• Step 1: Create a new report project using the steps under Start the Business Intelligence Development Studio (BIDS).
• Step 2: Create a Data Source, Data Set and connection to the database using the steps under Data Source, Data Sets and Connections.

Once you have completed the above two steps, you are ready to develop your report. For an example of a report you can create, see Meter Report Example.