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:

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.

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: