Overblog Follow this blog
Edit post Administration Create my blog
Balavardhan Reddy Narani

Beginning SQL Server 2005 - First Sample SSRS

January 20 2010 , Written by Balavardhan Reddy Published on #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. 1
    2. 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. 3
  8. Add New Report
    1. Right Clikc on the Report Folder from the Solution Explorer, select add new Item.
    2. 4
    3. 5
  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. 6
    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. 8
    4. Add the table control to Report UI page
    5. 9
    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. 10
    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. 11
    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. 15
  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. 16

Share this post

Repost 0
To be informed of the latest articles, subscribe:

Comment on this post

Muay Thai 01/14/2012 19:38

Nice dude. Love this one.

Air Jordan shoes 04/28/2010 08:38

Great article and it's so helpful. But I just can't see any picture in your blog. Is that my computer problem? But I can see other s' blog pics. what a nice shoe, it must very suitable and
comfortable for wear. Thanks for  the tip to visit your site.

Coach handbags 04/26/2010 08:24

Classic and real way of posting with interesting ideas and cool snaps.