{"id":458,"date":"2022-05-19T16:45:35","date_gmt":"2022-05-19T16:45:35","guid":{"rendered":"https:\/\/kindsonthegenius.com\/mssql\/?p=458"},"modified":"2022-05-19T16:45:35","modified_gmt":"2022-05-19T16:45:35","slug":"sql-server-reporting-services-ssrs-tutorial-for-beginners-part-2","status":"publish","type":"post","link":"https:\/\/www.kindsonthegenius.com\/mssql\/sql-server-reporting-services-ssrs-tutorial-for-beginners-part-2\/","title":{"rendered":"SQL Server Reporting Services (SSRS) Tutorial for Beginners \u2013 Part 2"},"content":{"rendered":"

In this tutorial, you will learn how to build a Table report using Reports Builder and publish the report to the Report Server. Then we’ll access this the report on a web page using the Web URL we set up in Part 1.<\/p>\n

    \n
  1. Install and Launch Reports Builder<\/a><\/li>\n
  2. Create a Data Source<\/a><\/li>\n
  3. Create a Dataset<\/a><\/li>\n
  4. Design a Table Report<\/a><\/li>\n
  5. Publish Your Report to the Web<\/a><\/li>\n<\/ol>\n

     <\/p>\n

    1. Install and Launch Reports Builder<\/strong><\/h4>\n

    In the Part 1 of SSRS Tutorial<\/a>, we setup SSRS Server and configures SSRS. In this tutorial, we would install Reports Builder and actually build reports.<\/p>\n

    Follow the steps below:<\/p>\n

    Download and install MS Report Builder from the link<\/a>.<\/p>\n

    After installation, launch Reports Builder and you will have the window below:<\/p>\n

    \"Reports<\/a>
    Reports Builder Window<\/figcaption><\/figure>\n

    Click on the Close(x) icon to exit this window.<\/p>\n

    At this point, you will see an empty reports page as shown below.<\/p>\n

    \"Blank<\/a>
    Blank Report Page in Reports Builder<\/figcaption><\/figure>\n

     <\/p>\n

     <\/p>\n

    2. Create a Data Source<\/strong><\/h4>\n

    Before you can create a data source, you must have some data in a database. In this tutorial, we would using the Northwind database. This is a free database you can add using Management Studio (see the video on how to do this).<\/p>\n

    Follow the steps below to create a data source<\/p>\n

    Step 1<\/strong> – Right-click on Data Sources and choose Add Data Source. The Data Source properties window opens. Modify as shown below (you can watch the video for if you need more details on this, but it’s quite easy)<\/p>\n

    I named it MyDataSource<\/p>\n

    \"Adding<\/a>
    Adding a data source to Reports Builder<\/figcaption><\/figure>\n

    Step 2<\/strong> – Click on Ok to close the window<\/p>\n

     <\/p>\n

    3. Create a Data Set<\/strong><\/h4>\n

    Next we need to create a dataset.<\/p>\n

    Step 1<\/strong>– Right-click on Datasets and select Add Dataset The Dataset properties windows opens up as shown in the figure<\/p>\n

    Step 2<\/strong> – Adjust the settings as shown:<\/p>\n