Creating an SSRS Report
SSRS (SQL Server Reporting Services) is reporting and visualisation tool for SQL Server. Using SSRS one can create, manage and publish reports and dashboards.
Figure out what Data Source will provide access to the data that you need. Generally, you’ll be using a shared data source that is hosted on reportview.tennessee.edu (or the dev or QA versions, reportviewdev and reportviewqas). The data sources provided there include connections to the various functional area repositories that make up the Consolidated Data Repository. For example, CDR_Student, CDR_Finance, etc.
If you don’t already have a data set suitable for this report, you’ll need to create one. Data sets can be created in Microsoft Report Builder. Just go to File > New, and choose Data Set. The data set is where you’ll enter the SQL query or stored procedure name that you’ll use to provide data for your report. The BI team can help you with this step. Be sure to save your data set to the reportview server so you can reuse in the future.
Once your dataset is ready, you can create a new report. In Microsoft Report Builder, go to File > New, and choose Report. You’ll want to select the data source and data set identified in steps 1 and 2. You can choose to use one of Report Builder’s wizards or you can work from a blank slate. Templates may also be available. If you already know of a report similar to the one you want to build, you can also open an existing report from the reportview server, save it as a new report, and modify it.
Make sure you save your report to the reportviewdev.tennessee.edu server. This is where we first try out new reports. Once it’s working, you can save it to reportviewqas.tennessee.edu for testing, and then once you’ve documented that it has been tested, you may save it to the production server reportview.tennessee.edu.
For more detailed assistance, you may wish to visit the Microsoft SQL Server Reporting Services Forum on MSDN.
If you would like some more in depth training, then go to Lynda.com, which is free for UT using your NetID, and watch ‘SQL Server Reporting Services in Depth’