I see this as a way of bringing the pivot tables of Excel to an SSRS report - to a degree, anyway.

I'll bet that a future version of SSRS will include a much easier way to accomplish this.

Creating something like this with report parts, generic enough to use as a template, would be the next logical step.