What’s New in Microsoft SQL Server Code-Named “Denali” for Reporting Services

SQL Server Reporting Services code names "Denali"
Will be much easier for end users to create their own reports.
Shared DataSets
Report Part Gallery
New visualizations (Map, Guage, Sparkline, Databar, KPI)
Ajax Report Viewer
Customer DCRs (defined customer requests)
They cut Adhoc reporting and alerting

Main Focus Areas:
Empower the end users
Crescent reports - this will be the new way to allow end users to create reports on the fly. It is presentation ready at all times and requires Silverlight because it is a Silverlight app. Only works with SharePoint mode.
Increased productivity
End user alerting
Increased Efficiency
Enable as SharePoint shared services
Report Performance Improvements

Must make a decision as whether you want to run in SharePoint mode or native mode before the install. Can't switch.

Need to remember that this is the version after SQL Server 2008 R2 and will not be implemented for some time. May want to enable the SharePoint mode now to administrate reporting services.

Office Open XML Rendering Extensions. Users will see this option in the export drop list in the report viewer and in the developer tools.

All this seems very cool, but is years away from being implemented at Weston. Although, if we want to work with a beta version we can load to VS 2010 and SSRS R2. This is not normally our policy.

Location:TechEd 2011