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

This book should be on the shelves any day now and is truly special! It draws from the experience of many Reporting Services industry experts and brings together best practices and report design patterns. I co-authored this book with Paul Turley, and...

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 past you may have provided valuable feedback through MSDN forums , Connect , blogs, conferences, and perhaps even discussed your ideas directly with members of the SQL Server Reporting Services product team. We appreciate all your suggestions,...

Yes this blog is still active, I have just been a bit too busy lately working on exciting future enhancements in Reporting Services as well as a book . Anyways, over the next weeks and months you can expect to see again frequent posts regarding new features...

A small stand-alone MSI for Report Builder 3.0, November CTP, is now available for download here . For a list of feature additions in November CTP, please refer to my previous blog post .

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

The PASS Community Summit 2009 is a don't-miss event for Microsoft SQL Server professionals. Whether you are a database administrator or a business intelligence professional, I believe you will benefit from the most up-to-date and comprehensive SQL Server...

Visual Studio 2010 Beta 2 is now available for public download !  This beta provides many new features, including an updated  ReportViewer control.  Beta 2 contains several important updates for the ReportViewer, such as using ASP.Net AJAX...

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

Chris Alton’s whitepaper on Reporting Services SharePoint Integration Troubleshooting is now available on MSDN. It provides a great set of configuration tips, diagnosis, and troubleshooting instructions. The following two older Reporting Services 2005...

A small stand-alone MSI for Report Builder 3.0, August CTP, is now available for download here: http://go.microsoft.com/fwlink/?LinkID=160384 Download packages for SQL Server 2008 R2 August CTP are available here: http://www.microsoft.com/downloads...

In a previous post , I demonstrated how to use a SQL Server spatial query as source for geospatial visualizations.  ESRI Shapefile is another type of spatial data supported in Reporting Services Maps in SQL Server 2008 R2 August CTP. There are a...

SQL Server 2008 R2 August CTP includes map visualization functionality in Reporting Services , as briefly described yesterday. In this posting, I’m going to provide an introduction of how to use spatial data and Bing Maps with 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...

Reporting Services 2005 with Matrix In a matrix in Reporting Services 2005, accomplishing multiple or different subtotal calculations at the same grouping level was difficult, but possible. If you wanted to accomplish custom subtotal calculations in...

At the traditional annual “BI Power Hour” sessions, several teams that contribute to the Microsoft Business Intelligence platform show off their technology in a fun way. It is about demonstrating, in perhaps unusual ways, of how business intelligence...

I have been pretty busy lately – working on SQL Server 2008 R2 , which is the official name for the next release, formerly known as SQL Server 'Kilimanjaro'. Earlier today at the Tech Ed 2009 Conference , Thierry D’hers demonstrated one...

Service Pack 1 for SQL Server 2008 is now available for download . The service pack is primarily a roll-up of Cumulative Updates 1, 2, and 3 and minor fixes made in response to requests reported through the SQL Server community. While there are no...

Tablix enables the separation of data groupings and layout header areas.  A stepped layout can help with horizontal spacing, because nested groups can then share the same horizontal space, which was previously not possible in a matrix layout. ...

SQL Data Services (SDS) was shown at PDC in October, utilizing a REST based interface. As described in a previous posting , we also made available a SDS custom data extension for Reporting Services reports. A few days ago, we announced that besides...

Just a quick post to reference two interesting reads about designing dynamic drilldown in reports: Sean Boon blogged about an approach to implement drilldown on charts with Reporting Services when Analysis Services is used as the data source. ...

Tablix is the new underlying flexible data region and grouping structure introduced in Reporting Services 2008. Among other features, it enables asymmetric layouts, as demonstrated in the thumbnail screenshot below. If you use a list, table, matrix...

In a previous post I showed how to quickly find reports that use custom report items (CRIs). The same idea can be applied to subreports as well. As an administrator of a report server, you may access the catalog database directly. Keep in mind that any...

Have you ever wondered what API calls Report Manager or Management Studio are performing to accomplish certain operations?  Teo Lachev’s RsTracer helps answer these questions.  The tool is available as a CodePlex project and shows the APIs that...