Microsoft SQL Server Reporting Services Tips and Tricks, How-to and Beyond

Most of the changes below are in both R2 and "Denali"

New in "Denali":
Merge DataSets
Can use DataSets Lookups with use of new Lookup Functions.
This is in R2 also.
Report Styles (available in R2):
Report Parts
Publishable RDL fragments
Promotes reuse
This is really nice if someone makes a standard report part like a header it can be saved and reused by everyone.

Multiple Result Sets - still unsupported - will have to write dynamic stored precedes.

RDL Object Model - still unsupported.

At this point in time Microsoft has not fixed many of the outstanding issues in "Denali" and R2. Some of the minor issues have been resolved.

New page break properties
ResetPageNumber
Disable - can be expression based

Rendering Enhancements
Can determine the export format
RenderFormat()
Vertical text
Can export to Word.
Can name the worksheets when exporting to Excel

Location:TechEd 2011