Apr 5, 2010

SQL Server 2008 R2 Reporting Services

R2 brings new Reporting Services features:

  • New Report Builder 3.0
  • Maps
  • Report components
  • Improvements in server mode


    • Product sales by shelf space
    • Integration with Bing Maps

Report Components

    • Parts of reports can be extracted as components and reused in other reports (i.e. datasets and reports items)
    • Users are notified when components are updated and can choose to download them

Shared Datasets

  • Share queries between reports
  • Saved in .rds files; deployed on report server
  • Pass parameters to it
  • Add filters and calculations
  • Can be cashed
    Maybe you thought that only new feature of SQL Server 2008 R2 is Power Pivot, but this is another good reason to upgrade your current version of SQL Server.

    No comments:

    Post a Comment