Post
Ask Question

SSRS (2) --- Client Setup: SSDT and Report Builder

Note: this article is published on 08/05/2024.

This series of articles will discuss SQL Server Reporting Services, including the related Services:

A - Introduction

The services discussed include:

  • SSIS --- SQL Server Integration Services
  • SSAS --- SQL Server Analysis Services
  • SSRS --- SQL Server Reporting Services
  • SSDT --- SQL Server Data Tools

The first article in this series discussesed the Server side Instalation and Configuration. This article will discusses the Client side (the Development Invironment) Installation and Configuration, inluding Visual Studio setup by installing Extentions and a Desktop app Report Builder.

  • A - Introduction
  • B - SSDT Installation
    • B.1 - Install SSDT with Visual Studio
    • B.2 - Install extensions for Analysis Services, Integration Services, and Reporting Services
      • B.2.1 - From the links to get the downloaded extensions
      • B.2.2 - From within Visual Studio to Install the extensions
        • VS 2022
        • VS 2019
      • B.2.3 - After the installations
        • Integration Service Project
        • Analysis Service Project
        • Report Server Project
  • C - Report Builder Installation
    •  
    • C.1 - Installation
    •  

B - SSDT Installation

We start from the SQL Server Installer => Click Install SQL Server Data Tools

Following the instruction:

B.1 - Install SSDT with Visual Studio

Running Visual Studio Installer and making sure you have the following conponents installed:

After installing SQL Server Data Tools, open Visual Studio 2022, we can see a project named: SQL Server Database Project:

B.2 - Install extensions for Analysis Services, Integration Services, and Reporting Services

You can install the Extensions either from the link in the page or from inside Visual Studio:

B.2.1 - From the links to get the downloaded extensions:

Extensions for Visual Studio 2022

B.2.2 - From within Visual Studio to Install the extensions:

VS 2022:

VS2019

B.2.3 - After the installations:

we have 

Integration Service Project:

Analysis Service Project:

Report Server Project:

This is a sample Report Server Project:

C - Report Builder Installation

Download  Report Builder from the Microsoft Download Center.

Install:

The default target server URL: http://localhost/ReportServer

After installation: Open Report Builder:

 

References:


Similar Articles