SSRS Tutorial: Part 6 - Create Report Using Report Wizard

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

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.

SSRS

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

SSRS

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

SSRS

Step 3 Build SQL Query

Click query builder to build SQL query.

SSRS

Right click on the plain surface and select add table.

SSRS

Select the table and click add.

SSRS

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

SSRS

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

SSRS

Step 4 Report Type

Select tabular radio button and click next.

SSRS

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

SSRS

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.

SSRS

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

SSRS

Step 5 Result

Here, the output is shown below.

SSRS