What's new in SSRS Denali #spc11 @kieferconsult

Carolyn Chau
Presented by Microsoft

• Recent upgrades to SSRS in 2008 SP2
• Shared DataSets
• Report Parts
• Visualizations
• Ajax Report viewer
• Customer DCRs
• Cuts
• Adhoc reporting
• Alerting
• Updates to SQL Server
• AlwaysOn
• Easily configurable readable clustered mirrored environments
• Denali Reporting and Alerting features
• SSRS will be include a SharePoint Service for integrated mode
• BIDS will be in Dev10
• The new SharePoint integrated mode
• One administration location: SharePoint Service config
• WCF and Claims support
• PowerShell Cmdlets
• ULS logging
• Scalable and load balanced
• Alerting
• SharePoint mode only
• One report per alert and conditions on data sources within report
• Only work against BIDS created (operational) reports
• Crescent (ad-hoc reporting)
• SharePoint mode only
• No alerting
• Silverlight 5 required
• Supports Chinese characters
• Supports Printing
• Integrated with PowerPivot
• RDLX files
• includes an rdl file plus others
• IT Experience
• Install RS add-in on SP WFEs
• Create and configure Central admin Service Application
• PowerShell Enabled