Configure Report Manager to open Report Builder 2.0 with ClickOnce

I was looking for a way to configure Report Manager to open Report Builder 2.0, instead of the default Report Builder 1.0 application. I was able to find this tidbit from the Report Builder 2.0 online help and thought I'd share.

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

Note: If you want to restore Report Builder 1.0 as the default version of Report Builder, update the Custom Report Builder URL field again. For Report Manager, use /ReportBuilder/ReportBuilder.application and for a SharePoint site, use /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application.

This tip assumes you have administrator privileges to SQL Server Reporting Services Report Manager.

Steps

To change the default ClickOnce application in Report Manager
1. Start Report Manager.
2. Click Site Settings.
3. Click General in the left pane.
4. In Custom Report Builder URL, type /ReportBuilder/ReportBuilder_2_0_0_0.application.
5. Click OK.

To change the default ClickOnce application in SharePoint Central Administration
On the Start menu, point to Administrative Tools and then click SharePoint 3.0 Central Administration.

On the Central Administration page, click the Application Management tab.

In Custom Report Builder URL, type: /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application.

Click OK.