Steps to Build a report

• Open a browser window and navigate to http://localhost/Reports (or to the appropriate Report Server URL if you're not working on the report server).
• Click the Report Builder link.
•  Depending on your operating system, you may have to confirm that you want to run the application.
• After Report Builder is loaded, select the AdventureWorks2008 report model and the table report layout. Click OK. Figure 17-12 shows the new blank report that Report Builder will create.

         

• Select the Product table.
• Drag the Name field and drop it in the area labelled Drag and Drop Column Fields.
• Click on Special Offer Products in the Explorer window to show related child tables.
• Click on Sales Order Details.
• Drag the Total Order Qty field and drop it to the right of the Name field.
•  Click where it says Click to Add Title and type Product Sales

Click the Run Report button to produce the report shown below

      

• Click the Sort and Group toolbar button.
• Select to sort by Total Order Qty descending.
• Click OK.
• Select File > Save.
• Name the new report Product Sales.
• Click Save. This will publish the report back to the Reporting Services server that you originally downloaded Report Builder from.