Steps to create report using Report Wizard

• Launch Business Intelligence Development Studio.
•  Select File > New >Project.
•  Select the Business Intelligence Projects project type.
•  Select the Report Server Project Wizard template
•  Name the new report ProductReport1 and pick a convenient location to save it in.
•  Click OK.
•  Read the first page of the Report Wizard and click Next.
•  Name the new data source AdventureWorksDS.
•  Click the Edit button.
•  Log on to your test server.
•  Select the AdventureWorks2008 database.
•  Click OK.
•  Click the Credentials button.
•  Select Use Windows Authentication.
•  Click OK.
•  Check the Make This a Shared Data Source check box. This will make this particular data source available to other Reporting Services applications in the future.
• Click Next.
•  Click the Query Builder button. 
•  If the full query designer interface does not display by default, click the query designer toolbar button at the far left end of the toolbar. Figure 17-2 shows the full query designer  interface.

         
    

• Click the Add Table toolbar button. 
• Select the Product table and click Add.
• Click Close
•  Check the Name, ProductNumber, Color, and ListPrice columns.
•  Click OK.
•  Click Next.
•  Select the Tabular layout and click Next.
•  Move the Color column to the Group area, and the other three columns to the Detail area

 

     

•  Click Next.
• Select the Stepped layout and click Next.
• Select the Ocean style and click Next.
• Accept the default deployment location and click Next.
• Name the report ProductReport1.
• Check the Preview Report checkbox.
• Click Finish.