Start Report Builder (Report Builder)

SQL Server 2012 Reporting Services (SSRS)  includes stand-alone and ClickOnce versions of Report Builder. The ClickOnce version can be used with Reporting Services installed in native or SharePoint integrated mode.

Note

Report Builder cannot be installed on Itanium 64-based computers. This applies to the ClickOnce and stand-alone versions of Report Builder.

If the ClickOnce version of Report Builder that opens is an earlier version of Report Builder, contact your administrator who can update Report Manager and the SharePoint site to use the SQL Server 2012 version of Report Builder

You can also use the ClickOnce version of Report Builder to create reports on a PowerPivot for Excel workbook that has been published to SharePoint. For more information about using Report Builder with PowerPivot, see Create a Reporting Services Report with PowerPivot Data on technet.microsoft.com.

To start Report Builder stand-alone from the Start menu on your local computer, you or an administrator must install Report Builder directly on your computer before the tool is available for you to use. The stand-alone version is not installed when you install SQL Server 2012; you must download and install it separately. To download Report Builder, see Microsoft® SQL Server® 2012 Report Builder.

To start Report Builder ClickOnce from Report Manager

  1. In your Web browser, type the URL for your report server in the address bar. By default, the URL is http://<servername>/reports. Report Manager opens.

  2. Click Report Builder.

    Report Builder opens and you can create a report or open a report on the report server.

To start Report Builder ClickOnce using a URL

  1. In your Web browser, type the following URL in the address bar:

    http://<servername>/reportserver/reportbuilder/ReportBuilder_3_0_0_0.application

  2. Press ENTER.

    Report Builder opens and you can create a report or open a report on the report server.

To start Report Builder ClickOnce in SharePoint integrated mode

  1. Navigate to the SharePoint site that contains the library you want.

  2. Open the library.

  3. Click Documents.

  4. On the New Document menu, click Report Builder Report.

    Report Builder opens and you can create a report or open a report on the report server.

    Note   If the New Document menu does not list the Report Builder Report, Report Builder Model, and Report Data Source options, their content types need to be added to the SharePoint library. For more information, see Add Report Server Content Types to a Library (Reporting Services in SharePoint Integrated Mode) in SQL Server Books Online on msdn.microsoft.com.

To start Report Builder stand-alone from the Start menu

  1. On the Start menu, click All Programs, and then click Microsoft SQL Server 2012 Report Builder.

  2. Click Report Builder .

    Report Builder opens and you can create or open a report.

  3. To create a new report, click the SQL Server icon in the upper left-hand corner of Report Builder, and then click New.

  4. To open an existing report stored on your local machine or a report server, click the SQL Server icon in the upper left-hand corner, and then click Open.

    If you don’t see the report server in the list of existing servers, close the Open Report dialog box and then click Connect at the bottom of Report Builder to connect to the server.

See Also

Concepts

Getting Started with Report Builder