Beginning SQL Server 2005 - First Sample SSRS

The easiest way to create a report in Report Designer is to use the Report Wizard. Like all wizards, the Report Wizard walks you through the process in step-by-step fashion. You can make the following choices in the wizard:

To create a simple report using the Report Project, follow these 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 template.
5. Name the new report ProductReport1 and pick a convenient location to save it in.
6. Click OK.
   
   1. 
      
   2. 
      
7. Add the Data Source to the Project,
   
   1. Right click on the Shared DataSources in the Solution Explorer and select the add shared DataSources.
   2. Provide Data Source name, Data Sour Type and Connection string for the Data Source in the immidiate window.
      
   3. 
      
8. Add New Report
   1. Right Clikc on the Report Folder from the Solution Explorer, select add new Item.
      
   2. 
      
   3. 
      
9. Create the Data Set for the Report
   1. Select New Data set from the Dataset Drop Down in the Data Tab of the Report page
   2. Select required Data Source Name for the Dataset
   3. Provided Name and Query for the Dataset and Click OK, then the Data tab wil looks like below.
      
   4. 
      
   5. It will shows the Data set Fields, Query and result in the Data tab
10. Display Data in the Table
    1. Select the Layout tab of the report.
    2. This tab will have the Toolbox, to add the different controls to report UI
       
    3. 
       
    4. Add the table control to Report UI page
       
    5. 
       
    6. Set the Dataset to table, by selecting the table Properties from the right click on the table control
    7. Here we also set the required Properties like, Displaying the Header and Footer rows values
       
    8. 
       
    9. Set the Data Fields to Detail Row of the table
       1. Right click on the Single cell of the Detail Row and Select the Properties to set the required Field to that Cell
       2. 
    10. Add Extra Columns to table
        
        
        
    11. Set the Color, Font and allign properties for each section (i.e. Header, Data, Footer)
        
        
        
        
        
    12. Select The Preview tab of the Report to View the Report
        
    13. 
        
11. Deplyment
    1. Select the Properties of the Solution file
    2. set the Start Item, Target URL, Target Folder Name.. etc
    3. After setting the above properties, right click on the Solution file and Click on the Deply, It will autometicallly Deploy the Project into your Target Folder.
       
    4.