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.
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 |
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.
|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.|
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
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
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
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>