Taking two powerful applications and integrating them can yield powerful results. Such is the case with SQL Server and SharePoint Server. And with the SharePoint Server 2010 and SQL Server 2008 R2 releases, the enhanced integration is significant. The main benefit in integration is that it allows you to view, store, and manage report server content on a SharePoint site or farm.
Alan Le Marquand has written a detailed and informative article, "Working Together: SQL Server 2008 R2 Reporting Services Integration in SharePoint 2010", which discusses how to configure and use these latest enhancements. Included are:
- Server Integration Architecture
- Configuring Integration
- Integration with Report Builder 3.0
- Using the Report View Web Part on a SharePoint site
- Claims Authentication and Reporting Services
- Native List Reporting
Check it out at http://technet.microsoft.com/en-us/magazine/ff686706.aspx.