SharePoint SQL Reporting Services Integration - SRG Networks, Houston, Texas

SQL Reporting Services 2005 (SSRS) SharePoint Integartion - SRG Networks, Houston, Texas

    

SQL Reporting Services is becoming popular enterprise reporting application in the industry today. Many corporations are using SSRS as abase reporting solution for their ERP applications such as SAP, Peoplesoft, Microsoft Great Plains and other line of business (LOB) applications. Similarly these corporations are also using SharePoint technologies (MOSS 2007 / WSS 3.0) as their primary portal, content management and information management system with excellent collaborative features such as document sharing and workflows. Prior to SQL Server 2005 Reporting Services SP2 release, reporting application were hosted separately from SharePoint environment and lot of independent software vendors (ISV) have developed SharePoint WebParts to host SSRS Report from SharePoint environment. This loosely coupled integration faced key challenges such as separate content source for reports and other business information hosted in reporting server and SharePoint sites and document libraries respectively. SharePoint was merely used as a front-end to display reports. Both applications managed their own security model prevailing complex security management in large organization. And on top f all both application had their own variation in user interface with additional complexity in report deployment methodologies. SQL Server Reporting Services 2005 (SSRS) SP2 (Service Pack 2) have eliminated these barriers in addition to other features that helps business users use both of these application effectively. Now you can view and manage reports within SharePoint and still keep all those reports synchronized with your base reporting application with integrated security model and unified user experience.

SRG Network has gained significant experience integrating SQL Reporting Services with Windows SharePoint Portal 2003 and Microsoft Office SharePoint Server 2007. Combination of these powerful tools have helped our clients building a scalable reporting application that provides good return on investment by lowering license, installation, support cost and improved uptime performance.


Please visit Microsoft SQL Server Reporting Services 2005 official website for more information.