RDL 2010, RPL, RGDI

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.  You can still download specifications for previous RDL…

0

Report Design: Naming Excel Worksheets

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 name of worksheets. The report item with the…

0

Globals!RenderFormat aka Renderer Dependent Report Layout

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 settings translate to HTML…

0

Report Design: Reset Page Number on Group

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 reset page numbers….

0

Refreshable Reports in Word, PowerPoint, Excel

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 a copy of the image, and also stores the link to…

0

SQL Server 2008 R2 November CTP – What’s New In Reporting Services?

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 an overview of what’s new in CTP…

0

Reports As Data Feeds for PowerPivot

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) and PowerPivotas powerful analysis tool. Enjoy!

0

SQL Server 2008 R2 August CTP – What’s New In Reporting Services?

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 knowing what’s new…

0

Take Another Look at CSV Rendering in RS 2008

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 you use complex report layouts…

0

Do You ▖ Unicode in PDF?

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 with SQL Server 2005 Service Pack 3 (SP3 download link), it is not…

0