In the new SQL Server 2008 R2 release it is the Reporting Services component that really changed a lot! For example one can now publish report parts (eg chart, table) which can be reused in different reports, or now you can also use SharePoint list as data source...


MSDN offers a great overview on new functionality: http://msdn.microsoft.com/en-us/library/ms170438.aspx

Here you can download the new version of authoring tool Report Builder 3.0: http://www.microsoft.com/downloads/details.aspx?FamilyID=f78b6b1e-8ccb-407a-bc3e-7955d60e1a6c&displaylang=en