Create SSRS Report Using Report Wizard

Introduction

This article demonstrates how to create a SSRS report. This article begins with a 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

Step 1

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

Step 2

• File => New => Project
• Business Intelligence Project => Report Server Project
• Give Project Name ... Select Location... Click OK
  
  
  
  

Step 3

• Right-click on Reports and Select Add New Report
  
  
  
  

Step 4

• Click on the Next Button
  
  
   

Step 5

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

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.
  
  
  
  

Step 7

• Press the Next Button
  
  
   

Step 8

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

Step 9

• Right-click and select Add Table
• Select Table and Click on the Add button
  
  
  
  

Step 10

• Select all columns and press the ok button
  
  
  
  

Step 11

• Click on the Next Button
  
  
  

Step 12

• Select Tabular Option and Click on the Next Button
  
  
   

Step 13

• Select PlayerName for the Group list and the Rest is for Details
• Click on the Next Button
  
  
  

Step 14

• Select Stepped option and Click on the next button
  
  
  

Step 15

• Select a table style and press the next button
  
  
  

Step 16

• Give the Report Name and Press the Finish Button
  
  
   

Step 17

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

Step 18

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

Conclusion

This is a very basic 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.