• Article

How to: Start Report Builder (Report Builder 3.0)

SQL Server 2008 R2 Reporting Services 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 3.0 cannot be installed on Itanium 64-based computers. This applies to the ClickOnce and stand-alone versions of Report Builder 3.0.

To start Report Builder ClickOnce in native mode, you click the Report Builder button in Report Manager or use the specified URL.

To start Report Builder in SharePoint integrated mode, you click the Report Builder Report option on the New Document menu.

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 2008 R2 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.

You start Report Builder stand-alone from the Start menu on your local computer. In contrast to the ClickOnce version, which you launch from Report Manager or a SharePoint library, 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 2008 R2; you must download and install it separately. For more information, see Installing, Uninstalling, and Supporting Report Builder 3.0.

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 How to: 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 2008 R2 Report Builder 3.0.

  2. Click Report Builder 3.0.

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

  3. Click Report Builder 3.0 Help to open the documentation for Report Builder.

Change History

Updated content

Added information about using Report Builder with PowerPivot for Excel workbooks.