My apologies I didn't see that it was for BIDS 2005. I've logged on to one of my old SQL Server 2005 machines and luckily it had BIDS 2005 installed on it so I could try.

Wow I forget how painfully bad that version was. The jump to 2008 is light years ahead. I can't work out how to do what I was suggesting in 2005, I'm sorry.

You may have to do something in the SQL to make it work, like make use of pivot/unpivot and cube/rollup.