SQL Server Reporting Services 2008 R2 introduces the RDL 2010 format with enhancements such as Maps, shared dataset references, page breaks , as well as RDL expression language additions such as Lookup, and aggregates of aggregates. You can now download the RDL 2010 specification as XPS file . ...

One of the frequent feature requests for Reporting Services was to add the ability to define data-dependent names for worksheets when exporting to Excel. Reporting Services 2008 R2 adds this capability through a more general feature to name pages. In Excel export , report page names determine the...

One of the design principles of the Reporting Services platform is that you author a report once, and it then renders to all interactive and export formats with as much fidelity as possible (and enabled by the underlying export format). You don’t need to worry how certain report items and style...

One of the frequent feature requests for Reporting Services was to add the ability to reset page numbers within the report, e.g. based on a change in the group value. Reporting Services 2008 R2 adds this capability through a more general feature to name pages, and define dynamic page breaks and optionally...

Microsoft Office supports several ways of embedding images into Office documents: Insert – statically inserts a copy of an image into the document. Link – creates a virtual connection with that image without actually embedding it in the document. Insert and Link – insert...

The November CTP download is available for MSDN and TechNet subscribers. The public download is available here . The feature pack download is now also available and includes Report Builder 3.0 as well as the RS add-ins for SharePoint 2007 and SharePoint 2010. The Data Platform Insider blog provides...

Donald Farmer explains in this one minute video how report data feeds (“the orange button”) are simply great data sources for further analysis in PowerPivot. You get the benefits of both, Reporting Services as platform with all its reporting and management features (e.g. role-based security, cache refresh...

The August CTP download is available for MSDN and TechNet subscribers. The public download is now also active here . The Data Platform Insider blog provides an overview of what's new in this first public CTP release for SQL Server 2008 R2. If you are reading my blog, you are probably interested in...

If you used the CSV renderer in previous releases of Reporting Services, you might want to take another look in RS 2008. We listened to your feedback: not only does CSV rendering consume significantly less resources and is faster in most cases, the CSV data output is generally more useful as well if...

One of the changes we included in Cumulative Update #1 for SQL Server 2008 ( CU1 download link ) is automatic full font embedding and subsetting for Unicode characters in Reporting Services 2008 PDF rendering . While a similar code change is now available for Reporting Services 2005 PDF rendering...