SSRS Tutorial: Part 6 - Create Report Using Report Wizard

Before reading this article, I highly recommend reading the previous part of the series.

• SSRS Tutorial Part 1 - Create A Simple Report
• SSRS Tutorial Part 2 - Shared Data Sources
• SSRS Tutorial Part 3 - Shared Datasets
• SSRS Tutorial Part 4 - Embedded Data Sources
• SSRS Tutorial Part 5 - Embedded Datasets

This article explains

• How to create a simple table report, using report wizard in SSRS with simple steps.

Step 1 Create your SSRS project

• If you’re using Microsoft SQL server 2012, go to search and select SQL Server Data Tools.
• Click File --> New --> Project --> Reporting Services --> Report Server Project.
• Provide a meaningful name to your solution and project. Specify the location of your solution by clicking on the browse.

Step 2 Add report

To add a report to your project, go to Solution Explorer (Short key: Ctrl + Alt + L) and right click on Reports. We can see different options like Add New Report, Add, Import Reports and Properties. Select Add New Report.



Once you click on add, the screenshot given below appears. Click next.



Please refer here to add the shared data source. Here, I am using the shared data source.



Step 3 Build SQL Query

Click query builder to build SQL query.



Right click on the plain surface and select add table.



Select the table and click add.



Select the column list, as shown below by selecting the checkboxes.



Click OK. Here, we can see SQL query with the selected columns. Click next.



Step 4 Report Type

Select tabular radio button and click next.



Select the columns under the available fields and click on the details.



Choose the table style to change the header background and font styles of your report. Click next.

Provide the report name, which is displayed on the top of your report. Click finish.



The wizard, mentioned below will appear and click preview to view the result.



Step 5 Result

Here, the output is shown below.