We had a request to update a URL in Central Admin so Report Builder 2.0 could be utilized when using RS in SharePoint Integrated Mode. There was more to this than met the eye.
The developer provided an MSDN link to an article that showed how to update a link in Central Admin. It didn't look like this would be enough to accomplish the goal so we researched a bit more and learned that we needed SQL 2008 SP1 applied. After doing that and updating the URL, it still wouldn't work (got page not found error when trying to edit a report using Report Builder from SharePoint), so we dug a bit more.
Found out that there is an update to the RS Add-in that needs to be run on the WFE.
However, there is a bug in the 64 bit RS Add-in update. The following workaround seems to solve the problem for us.
You can get RB2ClickOnce working if you copy the contents of
<SQLSEVERINSTALLDIR>\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\ReportBuilder TO C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\ISAPI\ReportBuilder.
Note: For above command, if you have a single server install the source and destination paths are on the same machine but if not, you copy from the DB server path to the WFE server path
Make sure you have a backup of the original <ISAPI>\ReportBuilder directory.
After you have copied the files you have to update the "Custom Report Builder launch URL" to
"/_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application".
So, in summary to get the Report Builder 2.0 functionality inside SharePoint for RS reports using SharePoint Integrated Mode do the following:
- Insure the original RS Add-in has been installed (not the "clickonce" exe that won't work)
- Insure SQL Server 2008 SP1 is installed
- Do the step to copy the folder as described above
- Update the Custom Report Builder launch URL (if not already done). This is found from Central Admin under Application Management > Reporting Services > Set Server Defaults.
- Verify all is well by going to a report library in SharePoint and "Edit in Report Builder" from the item menu. It should now open the RB 2.0 app.