Post
Ask Question

Create a Simple Report Using the Report Wizard - SSRS

Introduction

Creating attractive reports that summarize information in ways that make sense to business users has always been a challenge for developers. Since we can't do that using SQL Server, Microsoft provides SQL Server Reporting Services. Like Notification Services, reporting services was originally an add-on for SQL Server 2000, and now it's a part of the core product.

Steps

  1. Launch Business Intelligence Development Studio.
  2. Select "File" -> "New" -> "Project...".
  3. Select the Business Intelligence Projects project type.
  4. Select the Report Server Project Wizard template.
  5. Name the new project Reporting Views (give a name of your choice) and pick a convenient location to save it in.
  6. Click "OK".

    Creating Reporting Project
     
  7. Read the first page of the Report Wizard and click "Next".
  8. Name the new data source AdventureWorks2008 (give a name of your choice).

    DataBase Name
     
  9. Click the "Edit" button.
  10. Log on to your test server.
  11. Select the AdventureWorks2008 database. (Here you can select a database you have in your SQL.)

    Select DataBase Name
     
  12. Click "OK".
  13. Click the "Credentials" button from the second image.
  14. Select "Use Windows Authentication".

    Windows Authentication
     
  15. Click "OK".
  16. Check the "Make This Shared Data Source" checkbox. This will make this specific data source available to other Reporting Services applications in the future.

    Shared Data Source
     
  17. Click "Next".
  18. Click the "Query Builder" button.
  19. Click the "Add Table" toolbar button.

    Table ToolBar
     
  20. Select the respective table that you want to display in the report and click "Add".
  21. Click "Close".
  22. Now check the column names of the table.

    Table Column Name
     
  23. Click "OK".
  24. Click "Next".
  25. Select the Tabular layout and click "Next".
  26. Select your available fields to "Details" and click "Next".
  27. Choose the table style of your choice and click "Next".

    table style
     
  28. Accept the default deployment location and click "Next".

    Deployment Location
     
  29. Name the report Employee Report (give a name of your choice).
  30. Click "Next" and now you can see a report generated for an Employee.

     Generated Report

Conclusion

The Report Data window shows the data that is available to the report. The main design window lets you view the report itself. You can see a preview of the report, work with the report in a layout designer, or work with the query that returns the data for the report. The Solution Explorer, Output, and Properties windows are the standard Visual Studio windows.


Similar Articles