Prologika Forums
Making sense of data
Report Builder 3.0 Enhancements in R2 and SharePoint 2010 Mode

Blogs

Prologika (Teo Lachev's Weblog)

Training

Applied Microsoft SQL Server 2008 Reporting Services

We are excited to offer online Business Intelligence classes – no travel, no hotel expenses, just 100% content delivered right to your desktop!  Our first class is Applied Reporting Services 2008. Attend this class for only $799 and get a free paper copy of the book Applied Microsoft SQL Server 2008 Reporting Services by Teo Lachev!

For more information or to register click here! 

News

Syndication

Recent Posts

Tags

View more

Reporting Services Links

Analysis Services Links

Blog Roll

Archives

A couple of Report Builder enhancements in SharePoint 2010 integration mode caught my attention. First, Report Builder 3.0 now launches by default when the Open in Report Builder action is initiated inside SharePoint 2010. Previously, Report Builder 1.0 would be launched.

Second, if the report includes a drillthrough action to another report, the action now works when the action is initiated from Report Builder 3.0 preview mode. As it turns out, a drillthrough action is forwarded directly to SharePoint. Previously, a report drillthrough action will result in an error because the Report Builder would attempt to resolve the action locally.

Posted Tue, Jan 12 2010 10:06 PM by Teo Lachev
Filed under: ,

Comments

workerthread wrote re: Report Builder Enhancements in SharePoint Mode
on Wed, Jan 13 2010 8:25 AM

Hi Teo,

For me, this didn't work.  In my case Reporting Services R2 is on a different server to the SharePoint 2007 web front end.  The Open with Report Builder option went to URL sharepointserver/.../ReportBuilder.application which would not open the correct version (or any version come to that).  

I needed to copy the ReportBuilder folder from the Reporting Services server into an accessible location on the web front end then set up a custom launch URL as in previous version, except pointing to ReportBuilder_3_0_0_0.application.

Are you running a single server configuration?

Teo Lachev wrote re: Report Builder 3.0 Enhancements in SharePoint 2010 Mode
on Wed, Jan 13 2010 9:18 AM

Hi,

Sorry for not making this clearer but this applies to SharePoint 2010, R2, and Report Builder 3.0. With SharePoint 2010, the latest cummulative update pack configures ClickOnce automatically so you don't have to manually copy the folders, as I explained here prologika.com/.../report-builder-2-0-clickonce.aspx.

workerthread wrote re: Report Builder 3.0 Enhancements in R2 and SharePoint 2010 Mode
on Wed, Jan 13 2010 10:54 AM

Thanks for the clarification.  I can say that apart from some manual config of Report Builder the other R2 features work fine with SharePoint 2007.  

There is a separate download for the 2007 integration bits but once installed, use in multiple zones, connections to SharePoiint lists etc all seem to work fine.

Copyright © 2005 Prologika, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems
3DZL:andrewbelon.com