Report Builder 3.0 RTM

The Feature Pack for Microsoft SQL Server 2008 R2 was released for download earlier this week, and includes PowerPivot for Excel 2010, as well as Report Builder 3.0! The stand-alone download package for Report Builder 3.0 is available here: You can read about several of the new features and scenarios enabled with Report Builder…


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…


Book Reviews: Recipes for Designing Expert Reports, Introducing SQL Server 2008 R2

Teo Lachev is a well-known Reporting Services MVP, speaker at conferences, and authored several Reporting Services and Analysis Services books in the past.  Teo recently wrote a book review of “Reporting Services Recipes – for Designing Expert Reports” on this blog.  Enjoy!  In his review Teo says another title for this book might have been…


Report Design: Shrinking Hidden Static Table Columns

Reporting Services 2008 introduced the ability to dynamically hide table columns and shrink the width of the table (and the report body) at the same time automatically. That said, you also have the ability to just hide the contents, but not the actual table column and preserve the space. I see this question come up…


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….


Reporting Services in SharePoint 2010, Access Services

Besides releasing Reporting Services in SQL Server 2008 R2, we were busy working on a number of improvements for the Reporting Services SharePoint Add-in as well. SharePoint 2010 Reporting Services Add-in The SharePoint 2010 pre-requisite installer now automatically guides you to download and install the Reporting Services 2008 R2 for SharePoint 2010 Add-in.  Btw, you…


Visual Studio 2010 Report Viewer Available

In case you missed it in the recent wave of SQL Server, Visual Studio, and Office release announcements, Visual Studio 2010 was released in mid April and includes significantly enhanced ReportViewer controls. In server mode, the ReportViewer control can connect to and leverage the features of SQL Server 2008 R2 report servers, as well as…


SQL Server 2008 R2 RTM

  SQL Server 2008 R2 was just released to manufacturing (RTM) today. You can read more details about the overall SQL Server 2008 R2 release here.   SQL Server 2008 R2 is a big release, with new “editions” (MSDN contains the detailed feature by edition matrix), and includes also significant enhancements in Reporting Services. I summarized many…


Reporting Services 2005 Resources

MSDN information aggregator site for Reporting Services 2005.  Important downloads for Reporting Services 2005: SP4: SQL Server 2005 SP4 Cumulative Update #3 (build 9.00.5266) SQL Server 2005 SP4 Cumulative Update #2 (build 9.00.5259) SQL Server 2005 SP4 Cumulative Update #1 (build 9.00.5254) SQL Server 2005 SP4 RTM, Express Edition RTM (build 9.00.5000) SP3: SQL Server 2005 SP3…


Reporting Services Recipes Book Downloads

The Reporting Services Recipes book contains detailed step-by-step instructions and explanations for each report design recipe.  We also know that readers want to learn at their own pace, and sometimes don’t have the time to go step-by-step, but instead want to play with the final report first and then explore how it was built.  As…