Use the Report Viewer Web Part for SharePoint to Display SQl Server 2008 R2 Data as a Report or Build a Dashboard to Display Multiple Reports

Microsoft’s MSDN web site offers a set of documents on the Report Viewer Web Part (Reporting Services in SharePoint Integrated Mode). For readers who are not familiar with how the term “Report Viewer Web Part” is used by Microsoft, it is important to understand that the same term is used for two very different set of web parts. A short presentation of this potentially confusing broad use of the same terminology is explained on Report Viewer Web Parts for SharePoint, one of the blogs on MSDN. In sum, it is important to understand that a version of Report Viewer Web Parts is included with SQL Server Reporting Services. In addition, a version of Report Viewer Web Parts is included with the Reporting Services Add-In for SharePoint. Finally, SQL Server Reporting Services can run in native mode when the web parts are used with SQL Server 2008 R2. In contrast, SQL Server Reporting Services must be run in SharePoint Integration mode when the web parts are used with the Reporting Services Add-In for Sharepoint.

It is worth taking a moment to review a presentation, this time on Microsoft’s Technet web site, on configuring SQL Server 2008 R2 to run in SharePoint Integration Mode. Line of business (LOB) users and enterprise IT teams should note that this presentation summarizes the fact that using ” . . . any of the Reporting Services features on SharePoint such as PowerPivot, Access Services, or Report Builder 3.0, [requires that] you . . . change your configuration of SQL Server Reporting Services to SharePoint integrated mode”. Of course, both of these groups of users will likely have a high interest level in exploiting each of these three features, as appropriate for business intelligence (BI) gathering applications.

Using the Report Viewer Web Part for SharePoint when SQL Server Reporting Services are run in SharePoint Integration mode empowers users to not only embed a SQL Server report directly within a web app displayed on an Intranet running over SharePoint 2010, but also a series of SQL Server reports, which can be configured in a manner that provides management with a BI dashboard — complete with heat map color coding — for rapid identification of LOB performance againsts planned objectives. Certainly this type of capability will be highly valued by both LOB organizations and enterprise IT groups who may be able to save considerable cost by implementing SQL Server Reporting Services in this type of application.

It should be noted that readers interested in implementing the Reporting Services for SharePoint Add-In need to test system performance to determine whether the system performs satisfactorily with SQL Server Reporting Services running in SharePoint Integration mode.

In the next post to this blog we will provide a broad overview of the video training content offered by Rehmani Consulting, Inc for Reporting Services for SharePoint 2010.

© IMB Enterprises, Inc. & Ira Michael Blonder, 2012 All Rights Reserved
on behalf of Rehmani Consulting, Inc.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Comment moderation is enabled. Your comment may take some time to appear.