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".
   
   
    
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).
   
   
    
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.)
    
    
     
12. Click "OK".
13. Click the "Credentials" button from the second image.
14. Select "Use 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.
    
    
     
17. Click "Next".
18. Click the "Query Builder" button.
19. Click the "Add Table" toolbar button.
    
    
     
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.
    
    
     
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".
    
    
     
28. Accept the default deployment location and click "Next".
    
    
     
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.
    
     

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.