How to: Set Report Builder 1.0 as the Default ClickOnce Report Builder Version

SQL Server 2008 R2 provides a ClickOnce version of Report Builder 3.0 in addition to the standalone version released in the SQL Server 2008 R2 Feature Pack. ClickOnce is a Microsoft technology for deploying Windows applications. ClickOnce lets users install and run a Windows application such as Report Builder 3.0 by clicking a link on a Web page. Users can install and run Report Builder 3.0 from Report Manager or a SharePoint site.

By default, the ClickOnce application opens Report Builder 3.0. To change the default to Report Builder 1.0, you must update the value of the Custom Report Builder URL field in Report Manager. If you are opening Report Builder from a SharePoint site, you must update this field in SharePoint Central Administration.

Note

Report Builder 2.0 is not compatible with SQL Server 2008 R2 report servers.

To change the default ClickOnce application in Report Manager

  1. Start Report Manager.

  2. Click Site Settings.

  3. Click General in the left pane.

    In Custom Report Builder Launch URL, enter /ReportBuilder/ReportBuilder.application.

  4. Click Apply.

Note

To restore Report Builder 3.0 as the default, change the Custom Report Builder URL field back to /ReportBuilder/ReportBuilder_3_0_0_0.application.

To change the default ClickOnce application in SharePoint Central Administration

  1. In SharePoint 2010 Central Administration, click the General Application Settings tab.

  2. In the Reporting Services application section, click Set Server Defaults.

  3. In Custom Report Builder Launch URL, enter /_vti_bin/ReportBuilder/ReportBuilder.application.

  4. Click OK.

    Note

    To restore Report Builder 3.0 as the default, change the Custom Report Builder URL field back to _vit_bin/ReportBuilder/ReportBuilder_3_0_0_0.application.