Tablix – Multiple Subtotals Are Easy (aka Goodbye InScope)!

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 RS 2005, you may have heard about using the InScope function to dynamically determine the scope of a matrix…


Multi-Player Gaming in RS (aka BI Power Hour 2008)

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 and various tools of the BI stack can be useful. In past years, Reporting Services made a…

4

SQL Server 2008 R2, Tech Ed 2009

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 of the many projects I have been working on recently – it is our cool…


SQL Server 2008 SP1 and Report Builder Update

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 new features in this service pack, a notable addition from a…


Tablix – Stepped Layout

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.  This provides very powerful layout capabilities, and is one among several new features introduced with Tablix. A…

1

Reporting and SQL Data Services

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 the REST interface, SDS will also expose SQL Server’s existing network protocol, Tabular…


Dynamic Drilldown in Reports and Charts

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.  Chris Webb then created a great blog posting on how to implement drilldown for Analysis Services based…


Tablix – The Matrix Revolution

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, chart, gauge, or custom report item in RS 2008, you are really using a tablix beneath the covers. …

2

Subreport Usage

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 queries you execute directly against the report server’s catalog…

1

RS Tracer

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 a Reporting Services client invokes and what arguments it passes to each interface. It also intercepts the…