Setting Report Builder 2.0 as the Default ClickOnce Report Builder Version (Native and MOSS Integrated)
Once you've installed SQL Server 2008's SP1 (download here), I'm sure you'll want to have Report Builder 2.0's click once feature activitated. By default, SSRS will still call Report Builder 1.0 application. Here are steps needed to enable click once for Report Builder 2.0
To change the default ClickOnce application in Report Manager for "Native" mode:
-
Start 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 for MOSS Integrated mode (note you'll need to download the SP1 update for MOSS Integrated mode, plus the Report Builder Click once update as well...both found here):
-
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.
-
Under the Reporting Services section, click on Set Server Defaults
-
In Custom Report Builder URL, type: /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application.
-
Click OK.
