SSRS Tutorial: Part 6 - Create Report Using Report Wizard

Introduction

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 the 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 for 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 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 the SQL queries with the selected columns. Click next.

SSRS

Step 4. Report Type

Select the 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 your report's header background and font styles. Click next.

Provide the report name, which is displayed at 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

Conclusion

In this article, we learned how to create a simple table report using the report wizard in SSRS with simple steps.


Similar Articles