Step by Step procedure to create first SSRS repport

SSRS : step by step method to create simple report

1. Open visual studio 2013 blend.
2. Select File -> New -> Project
3. Select Report Server Report Wizard as shown below.
   

4. Following dialog box will open

5. Give name to New DataSource and click on Edit to set connection properties. We are selecting adventureworks database  

 

 

6. Now the report wizard will show Query builder window. Click on Query Builder.   

Select Edit as Text. Write your desired Query, command Type : Text or stored procdure , command type : StoredProcedure. Run Query to verify result.

 

 

7. At last set report formatting, like report type tabular or matrix, grouping, paging, etc. Give name to the report and preview your report.