Edit

Install Microsoft Report Builder

  • Article

Applies to: ✅ SQL Server 2016 (13.x) Reporting Services and later ✅ Power BI Report Server

Microsoft Reporting Services is a stand-alone app for authoring paginated reports, installed on your computer by you or an administrator. An administrator typically installs and configures Reporting Services, grants permission to download Reporting Services from the web portal, and manages folders and permissions to reports and shared datasets saved to the report server. For more information about Reporting Services administration, see Reporting Services report server (native mode).

There are different ways to install Report Builder.

Your administrator can install Report Builder with Microsoft Endpoint Configuration Manager.

And you can install it from several places:

Note

Are you looking for Power BI Report Builder instead? Head to the Microsoft Power BI Report Builder page on the Download Center.

System requirements

See the System requirements section of the Report Builder download page on the Microsoft Download Center.

Install Report Builder with Microsoft Endpoint Configuration Manager

An administrator can use software such as Microsoft Endpoint Configuration Manager to push the program to your computer. To learn how to use specific software to install Reporting Services, consult the documentation for the software. For more information, see Microsoft Endpoint Configuration Manager documentation.

Important

Windows Vista and Windows 7 security features require elevated permissions to run command line operations and will prompt for permission to run the command line. The installation is not silent. To make the installation silent, you need to run the command line as an administrator.

Install Report Builder from the web portal

Note

You can install Report Builder from a SharePoint library integrated with Reporting Services through SQL Server 2016.

You can start Reporting Services from a Reporting Services web portal or a SharePoint site integrated with Reporting Services. For information, see Start Report Builder.

SharePoint site integrated with Reporting Services

On a SharePoint site integrated with Reporting Services, if the New Document menu doesn't list Report Builder Report, Report Builder Model, and Report Data Source, their content types need to be added to the SharePoint library. For more information, see Add Reporting Services Content Types to a SharePoint Library.

Install Reporting Services from the download site

  1. On the Report Builder page of the Microsoft Download Center , select Download.

  2. After Reporting Services finishes downloading, select Run.

    This step launches the SQL Server Reporting Services Wizard.

  3. Accept the terms in the license agreement and select Next.

  4. On the Default Target Server page, optionally provide the URL to the target report server if it's different from the default. Select Next.

    Note

    If you'd like to work with Reporting Services when it's connected to a report server, it's convenient to provide the URL to the server at this time. You can also do this from the Options dialog box in Reporting Services.

  5. Select Install to complete the installation of Reporting Services.

Install Report Builder from a share

  1. Contact your administrator for the location of ReportBuilder.msi that you run to install Reporting Services on your local computer.

  2. Browse to locate ReportBuilder.msi, the Windows Installer Package (MSI) for Reporting Services, and select it.

    This step launches the SQL Server Reporting Services Wizard.

  3. Complete rest of the steps in To install Report Builder from the download site.

Install Report Builder from the command line

You can also perform a command line installation of Reporting Services and provide arguments to customize the installation. In addition to the standard MSI intrinsic parameters, you can use the custom parameters that Reporting Services provides: RBINSTALLDIR and RBSERVERURL. RBINSTALLDIR specifies the root installation folder for Reporting Services. RBSERVERURL specifies the default report server that Reporting Services uses to save reports on the server.

If you want a silent installation, with no user interface interaction at all, specify the /quiet option. By design, the quiet option flag suppresses installation errors. It's therefore recommended that you include the /l option, which specifies logging, when you use the quiet option.

  1. On the Report Builder page of the Microsoft Download Center, select Download.

  2. After Reporting Services finishes downloading, select Save.

  3. On the Start menu, select Run.

  4. In the Open box, enter cmd.

  5. In the Command Prompt window, navigate to the folder where you saved ReportBuilder.msi.

  6. Enter a command with the following format:

    msiexec /i ReportBuilder.msi OPTION=OptionValue [OPTION=OptionValue]

    The two options specific to installing Reporting Services are: RBINSTALLDIR and RBSERVERURL. You don't have to include these arguments in the command line. The following example is the baseline command:

    msiexec /i ReportBuilder3_x86.msi /quiet

  7. To run the command, press ENTER.

Set Reporting Services defaults

  • After you install Reporting Services, you can set some default options. Select File > Options.

    Setting the default Reporting Services web portal or SharePoint site is the most useful. For more information, see Set default options for Report Builder.

  • Select Report Builder .

    If you don't see the report server in the list of existing servers, close the Open Report dialog box and then select Connect at the bottom of Reporting Services to connect to the server.

Related content