SQL SSRS Tutorial

SQL Server Reporting Services let you create reports and output data for users who have access to your reports server. SQL Server provides a graphical-friendly interface with templates that developers use to display the data. The reports developer chooses the template, sets up the query and publishes the report on the server. The SSRS service makes it more convenient to set up reports, because the developer does not need to create the layout.

Instructions

1. Open the SSRS editor from the Windows program menu on the database server. Click "New" and "Project," then click "Business Intelligence Projects" for the project type and select "Report Server Project." Click "Tutorial" for the new project name and click "OK" to create the new project.

2. Click the "New Dataset" option from the Dataset list in the navigation panel. This button opens a configuration window where you specify the connection string. Select the database name, server name, and the username and password used to connect to the server. Click "OK."

3. Type a query in the query editor for the report. For instance, to retrieve a list of customers to display in the report, type the following code:

   select * from customers.

4. Click the "Save" button to save the changes. Click "Preview" in the toolbar to review the report and its data.

References

• Microsoft MSDN: Creating a Report Server Project
• Microsoft MSDN: Setting Up Connection Information