Create SSRS Report Using Report Wizard

Introduction

This article demonstrates how to create an SSRS report. This article begins with an SSRS Introduction, then the use of SSRS, and finally step-by-step creation of a report.

What is SSRS?

SSRS is a server-based reporting platform. It provides tools and services to create, manage and deploy reports.

We can use SSRS for

  • Business Reporting
  • Ad hoc Reporting
  • Embedded Reporting
  • Portal Integration

Report Development Process

Report-Development-Process.jpg

Step 1

Start => All Programs => SQL Server 2008 R2 => SQL Server Business Intelligence Development Studio.

![Sql -Server-Business-Intelligence-Development-Studio.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/Sql%20-Server-Business-Intelligence-Development-Studio.jpg)

&nbsp;</span>

Step 2

File => New => Project

Business Intelligence Project => Report Server Project.

Give Project Name ... Select Location... Click OK

![business-intellegence-project.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/business-intellegence-project.jpg)</span>

&nbsp;

Step 3

Right-click on Reports and Select Add New Report.

![Reports-and-Select-Add-New-Report.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/Reports-and-Select-Add-New-Report.jpg)</span>

&nbsp;

Step 4

Click on the Next Button.

![report-wizard.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/report-wizard.jpg)

&nbsp;</span>

Step 5

Give a Data Source name and Click on the Edit Button.

![select-the-data-source.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/select-the-data-source.jpg) </span>

Step 6

Select Server Name

Select "Use SQL Server Authentication" Radio Button

Give User name and Password

Select Database Name and Click on the "OK" button.

![select-database.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/select-database.jpg)</span>

&nbsp;

Step 7

Press the Next Button

![select-the-data-source1.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/select-the-data-source1.jpg)

&nbsp;</span>

Step 8

Click on the "Query Builder ..." button, as in:

![design-the-query.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/design-the-query.jpg)</span>

Step 9

Right-click and select Add Table

Select Table and Click on the Add button

![query-designer.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/query-designer.jpg)</span>

&nbsp;

Step 10

Select all columns and press the ok button

![Select-all-columns.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/Select-all-columns.jpg)</span>

&nbsp;

Step 11

Click on the Next Button

![next-burron-query-builder.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/next-burron-query-builder.jpg)</span>

Step 12

Select Tabular Option and Click on the Next Button

![select-the-report-type.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/select-the-report-type.jpg)

&nbsp;</span>

Step 13

Select PlayerName for the Group list, and the Rest is for Details

Click on the Next Button

![design-the-table.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/design-the-table.jpg)</span>

Step 14

Select the Stepped option and Click on the next button

![choose-the-table-layout.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/choose-the-table-layout.jpg)</span>

Step 15

Select a table style and press the next button

![choose-the-table-style.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/choose-the-table-style.jpg)</span>

Step 16

Give the Report Name and Press the Finish Button

![completing-the-wizard.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/completing-the-wizard.jpg)

&nbsp;</span>

Step 17

PlayerReport.rdl is added in the Reports folder, and you can see the rdl file in design mode.

![PlayerReport.rdl.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/PlayerReport.rdl.jpg)</span>

Step 18

To see the preview of the report, Click on the preview tab

![preview-of-report-Click.jpg](/UploadFile/db2972/create-ssrs-report-using-report-wizard/Images/preview-of-report-Click.jpg)</span>

Conclusion

This is a fundamental and simple report of SSRS. You can also customize table layout, style, report type, etc. In this report, I have used only a single table. You can also create a report using multiple tables with the help of joins.


Similar Articles