ARTICLE

Create SSRS Report Using Report Wizard

Posted by Akshay Patel Articles | SQL September 17, 2012
This article demonstrates how to create SSRS report. This article begins with the SSRS Introduction, Use of SSRS and step by step creation of report.
Reader Level:

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

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
     

Step 2

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

    business-intellegence-project.jpg

Step 3

  • Right-click on Reports and Select Add New Report

    Reports-and-Select-Add-New-Report.jpg

Step 4

  • Click on the Next Button

    report-wizard.jpg
     

Step 5

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

    select-the-data-source.jpg


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

Step 7

  • Press the Next Button

    select-the-data-source1.jpg
     

Step 8

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

    design-the-query.jpg


Step 9

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

    query-designer.jpg

Step 10

  • Select all columns and press the ok button

    Select-all-columns.jpg

Step 11

  • Click on the Next Button

    next-burron-query-builder.jpg


Step 12

  • Select Tabular Option and Click on the Next Button

    select-the-report-type.jpg
     

Step 13

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

    design-the-table.jpg


Step 14

  • Select Stepped option and Click on the next button

    choose-the-table-layout.jpg


Step 15

  • Select a table style and press the next button

    choose-the-table-style.jpg


Step 16

  • Give the Report Name and Press the Finish Button

    completing-the-wizard.jpg
     




Step 17

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

    PlayerReport.rdl.jpg


Step 18

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

    preview-of-report-Click.jpg


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.
 

COMMENT USING