Edit post Follow this blog Administration + Create my blog

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
To be informed of the latest articles, subscribe:
Comment on this post

part time maids in dubai 04/12/2020 11:52

when ındividuals are fully pre-occupied with stressful lifestyles together with hectic lives, there is minor time to carry out the many household hobbies. Cooking, cleaning and coping with the house and also kids become a challenging romance.

shawcorsuccess.com 01/30/2020 12:10

Bear in mind you making the effort to promote your home-based business and together with articles they may be NOT commercials. You may well not attempt to offer the audience anything except the fact you provide an interesting subject and so they may want to click the link or perhaps visit an individual site/offering.

cleaning company uae 05/12/2019 08:55

Live-In companies are for your families who would like to have any maid without the hassle. The cleaning service lives on the client’s dwelling from Weekend to Thursday night. We offer our finest maids with all the current necessary legitimate documentation and also formalities like medical insurance, visa and so forth. Our Live-in maids are well competed in cleaning and caring for juniors.

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.