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

In this Part 1 of SQL Server Reporting Services (SSRS) Tutorial for Beginners, you will learn how to the basics of Reporting Services and how to set up SSRS on your Windows computer and create your first report using MS Report Builder.<\/p>\n

We would cover the following content<\/p>\n

    \n
  1. Download Setup SQL Server<\/a><\/li>\n
  2. Setup SQL Server Management Studio<\/a><\/li>\n
  3. Install SQL Server Reporting Services<\/a><\/li>\n
  4. Configure SSRS<\/a><\/li>\n
  5. Connect to SSRS and Register a Report Server<\/a><\/li>\n
  6. Install Reports Builder<\/a><\/li>\n
  7. Create and Publish Your First Report<\/a><\/li>\n<\/ol>\n

     <\/p>\n

    1. Download Setup SQL Server<\/strong><\/h4>\n

    The first step is to download and install SQL Server<\/p>\n

    You can get it from this link.<\/p>\n

    https:\/\/www.microsoft.com\/en-us\/sql-server\/sql-server-downloads<\/a><\/p>\n

    It’s necessary to have some knowledge of databases before get into SQL Server Reporting Services (SSRS).<\/p>\n

     <\/p>\n

    2. Setup SQL Server Management Studio<\/strong><\/h4>\n

    Download and install SQL Server Management Studio (SSMS). This is the application you can use to manage databases.<\/p>\n

    You can download it from this link – https:\/\/docs.microsoft.com\/sql\/ssms\/download-sql-server-management-studio-ssms<\/a><\/p>\n

    \"SQL<\/a>
    SQL Server Management Studio<\/figcaption><\/figure>\n

     <\/p>\n

    3. Install SQL Server Reporting Services<\/strong><\/h4>\n

    Now, you must install SQL Server Reporting Services.<\/p>\n

    You can download it from here – https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=100122<\/a><\/p>\n

    Once you download it,\u00a0 just go ahead to install it. Then you will have the Report Server Configuration Manager.<\/p>\n

    After the installation, you can open the configuration manager as shown below:<\/p>\n

    \"SSRS<\/a>
    SSRS Server Configuration Manager<\/figcaption><\/figure>\n

     <\/p>\n

     <\/p>\n

    4. Configure SQL Server Reporting Services (SSRS)<\/strong><\/h4>\n

    When you open configuration manager, click on Connect.\u00a0 The follow the steps below to complete the configuration.<\/p>\n

    1.\u00a0 Configure Web Service URL<\/strong>. Click on Web Service URL link on the left and then click on Apply as shown below:<\/p>\n

    \"Web<\/a>
    Web Service URL Configuration<\/figcaption><\/figure>\n

    2. Configure the Database:<\/strong> Click on the Database tab on the left and follow the instructions to set up the Report Server Database.<\/p>\n

    \"Database<\/a>
    Database Configuration<\/figcaption><\/figure>\n

    3. Configure Web Portal URL<\/strong> – Click on the Web Portal URL and just click on Apply as shown below:<\/p>\n

    \"Configure<\/a>
    Configure Web Portal URL<\/figcaption><\/figure>\n

    At this point, the SSRS Configuration is complete and you can exit.<\/p>\n

     <\/p>\n

    5. Connect to SSRS and Register a Report Server<\/strong><\/h4>\n

    To use reporting services, you need to register the server in SQL Server Management studio. Open Management Studio.<\/p>\n

    Goto View > Registered Servers.<\/p>\n

    Then follow the instruction to registers\u00a0 the reporting server you earlier configured.<\/p>\n

    \"Register<\/a>
    Register Report Server<\/figcaption><\/figure>\n

     <\/p>\n

    In the next tutorial, we would then Install MS Reports Builder and create our first report<\/p>\n

      \n
    • Install Reports Builder<\/li>\n
    • Create and Publish Your First Report<\/li>\n<\/ul>\n

       <\/p>\n","protected":false},"excerpt":{"rendered":"

      In this Part 1 of SQL Server Reporting Services (SSRS) Tutorial for Beginners, you will learn how to the basics of Reporting Services and how … <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[23],"tags":[35,36],"class_list":["post-444","post","type-post","status-publish","format-standard","hentry","category-ms-sql-server","tag-sql-server-reporting-services","tag-ssrs"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/posts\/444","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/comments?post=444"}],"version-history":[{"count":4,"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/posts\/444\/revisions"}],"predecessor-version":[{"id":457,"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/posts\/444\/revisions\/457"}],"wp:attachment":[{"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/media?parent=444"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/categories?post=444"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kindsonthegenius.com\/mssql\/wp-json\/wp\/v2\/tags?post=444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}