03/10/2009 10:31:15

SQL Server 2008 PCU1 provides a ClickOnce version of Report Builder 2.0. If Reporting Services is installed in SharePoint integrated mode you need to install the add-in, Microsoft® SQL Server® 2008 Report Builder 2.0 ClickOnce for SharePoint, to make Report Builder 2.0 ClickOnce available from a SharePoint site.

Note:
To open the ClickOnce version of Report Builder 2.0 from a SharePoint site, you must also have the Microsoft® SQL Server® 2008 Reporting Services Add-in for SharePoint Technologies installed. This Web download provides features for running a report server in a larger deployment of Microsoft Windows® SharePoint® Services 3.0 or Microsoft Office SharePoint Server 2007. You can download this from the Microsoft Download Center.

The Report Builder 2.0 ClickOnce for SharePoint add-in has a few known issues, which are documented here.

Report Builder 2.0 is not the default version of Report Builder ClickOnce on the 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. 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 a SharePoint site, use /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application.

Procedures

To change the default ClickOnce application in SharePoint Central Administration

  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. In Custom Report Builder URL, type: /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application

  4. Click OK.

Symptom: Local preview is not available

The error message "Failed to load configuration file 'ReportDesigner.config'. Local preview will not be available" appears.

The computer on which you are installing the Report Builder 2.0 ClickOnce application does not have Microsoft .NET Framework version 3.5 Service Pack 1 installed. Either the .NET Framework is not installed at all or a different version is installed.

To correct the problem, install Microsoft .NET Framework 3.5 Service Pack 1. The service pack is available at the Microsoft Download Center.

Symptom: Report Builder 1.0 opens instead of Report Builder 2.0

Although you have set Report Builder 2.0 as the default ClickOnce version, Report Builder 1.0 opens instead from the SharePoint site.

This occurs because the user does not have sufficient permissions to get the value of the Custom Launch URL property, which is the property that you set to Report Builder 2.0. Because the value of the Custom Launch URL property is not available, the ClickOnce version reverts to Report Builder 1.0.

To correct this problem, install the updated version of SQL Server 2008 Reporting Services Add-in for SharePoint. It is available at the Microsoft Download Center.

Symptom: Report Builder 2.0 ClickOnce cannot be opened from a SharePoint site

The files related to Report Builder 2.0 ClickOnce that are deployed to the SharePoint server require authentication. When the server uses Forms authentication, authentication fails and Report Builder 2.0 ClickOnce cannot be opened. The same applies to Report Builder 1.0.

To correct this problem, an administrator needs to update the Web.config file. A <location> element must be added within the <configuration> element. The following code shows the XML from the Web.config file.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<configuration>
...
<location path="_vti_bin/ReportBuilder" allowOverride="false">
     <system.web>
       <authorization>
         <allow users="*" />
       </authorization>
     </system.web>
</location>
</configuration>