How to: Set Report Builder 2.0 as the Default ClickOnce Report Builder Version
SQL Server 2008 PCU1 provides a ClickOnce version of Report Builder 2.0 in addition to the standalone version that released in the SQL Server 2008 Feature Pack. ClickOnce is a Microsoft technology for deploying Windows applications. ClickOnce enables users to install and run a Windows application such as Report Builder 2.0 by clicking a link on a web page. Users can install and run Report Builder 2.0 from Report Manager or a SharePoint site.
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./ReportBuilder/ReportBuilder.application.
To change the default ClickOnce application in Report Manager
Click Site Settings.
Click General in the left pane.
In Custom Report Builder URL, type /ReportBuilder/ReportBuilder_2_0_0_0.application.
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.