SQL Server 2008 SP2 provides a roll-up of previous cumulative updates and also contains enhancements for Reporting Services SharePoint integration.
Report servers with SP2 can integrate with SharePoint 2010 products. SP2 also provides a new add-in for integrating with SharePoint 2007 products. In addition, the new add-in supports the integration of SharePoint 2007 products with SQL Server 2008 R2 report servers.
Summary of updates with SP2:
Integration with SharePoint 2010 products
RS 2008 SP2 add-in for SharePoint 2007 products.
Integration of SharePoint 2007 products with RS 2008 R2 report servers.
More information on what's new in Reporting Services 2008 SP2.