title: Group and subtotal columns in Reporting Services 2005
body: <p>I have a report (RS2005, against a MSSS2005 instance) which I have inherited. It shows a basic table of data: a handful of key fields which are used to group rows together, a few basic numeric fields, then a number of dated ('bucketed') fields (e.g. 1 month away, 2 months, 6 months, a year, 2 years, etc.) </p>
  
  <p>The user would like to group together these dated fields in aggregated groups and be able to collapse or expand the <strong>columns</strong> as you can the rows. So we'd be able to show the next year's values' subtotal or expand it to break it out by month. Hiding the invidual months if the subtotal is shown. </p>
  
  <p>This is basic pivot table behaviour (and can be done with the Group/Subtotal feature on Excel - that's the closest analogous behaviour I could use to describe the requirements). </p>
  
  <p>While grouping by rows seems trivial in RptgSvcs, grouping columns and collapsing a group into a single subtotal and blowing it out again, seems hard to impossible. </p>
  
  <p>Unless someone knows better? </p>