Install SSRS Report builder

The SQL Server Reporting Services allows designing Reports using two applications such as BIDS and SSRS Report Builder.

  • Business Intelligence Development Studio (Shortly called BIDS). Please refer Install Data Tools article to understand the steps involved in installing the BIDS.
  • Report Builder – Simple tool to design both basic and complex reports without having Visual Studio knowledge.

Developers who prefer to work in the Microsoft Office environment will prefer Report Builder as their best bet to design, edit, and publish Reports.

In the early years, Report Builder is fixed to design a simple report. However, using SQL Report Builder 3.0, you can create the most complex reports. In this article, we will show you how to install the SSRS Report Builder from the Report Manager.

Steps to Install SSRS Report builder

To install it, Please open your SSRS report manager and click on the Report Builder, as shown in the below screenshot.

Click on the Report Builder Icon 1

Clicking the Menu will check whether the Report Builder application is installed or not.

Launching the Application 2

If found, then SSRS will open.

Report Builder Download

Otherwise, the Downloading Report Builder window will open to download the application.

Wait until Downloading the software window closes 3

Once the Microsoft SQL Server Report Builder is downloaded to 100%, it will open with a starting page, as shown in the below screenshot.

Using Report Builder, we can design Tables, matrices, charts, Sparklines, Data Bars, Charts, Gauges, and Map reports. It ranges from simple reports to complex reports.

Install SSRS Report Builder 4

For now, we selected the Blank Report.

Create a New Chart 5

You can use the above SSRS Report Builder window to design any report possible by Visual Studio. The following are some of the examples.

  1. New Dataset using this builder
  2. New Table, or Matrix using the builder Wizard
  3. Create Table Without Wizard
  4. Pie Chart using Wizard
  5. Bar Chart without a Wizard