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:

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 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):

1. On the Start menu, point to Administrative Tools and then click SharePoint 3.0 Central Administration.

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

3. Under the Reporting Services section, click on Set Server Defaults

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

5. Click OK.

Comments

• Anonymous
  June 24, 2009
  PingBack from http://www.decatec.it/blogs/2009/06/24/SHarepoint+SQL+2008+SP1+Report+Builder+20.aspx

• Anonymous
  June 26, 2009
  The comment has been removed

• Anonymous
  November 05, 2009
  Is there any way to use a custom Report Builder URL in WSS?  We only have one model and I would like to pass that in when someone adds a new report using Report Builder.