The SQL Server Reporting Services allows designing Reports using two applications such as BIDS, and SSRS Report Builder.
- Business Intelligence Development Studio (Shortly called as BIDS). Please refer Install SQL Server Data Tools article to understand the steps involved in installing the BIDS
- SSRS 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 SSRS Report Builder as their best bet to design, edit, and publish SSRS Reports.
In the early years, SSRS 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 SSRS report builder, Please open your report manager and click on the Report Builder as shown in below screenshot
Clicking the Report Builder check whether the SSRS Report Builder application installed or not.
If found, then SSRS Report Builder will open.
SSRS Report Builder Download
Otherwise, Downloading Report Builder window will be opened to download the application
Once the Microsoft SQL Server Report Builder downloaded to 100%, it will be opened with a starting page, as shown in the below screenshot.
Using SSRS Report Builder, we can design Tables, matrix, Chart, Sparklines, Data Bars, Charts, Gauges, and Map reports. It ranges from simple reports to complex reports.
For now, we selected the Blank Report.