SSRS Tutorial: Part 6 - Create Report Using Report Wizard

Introduction

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 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 

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

Step 4. Report Type

Select the tabular radio button and click next.

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

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.

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

Step 5 Result

Here the output is shown below.

Conclusion

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