Is it possible to create column Grand Totals in a table in an SSRS 2005 report? If I try to add a footer in my table then do a SUM on a Group's field above it, it tells me that it's not possible to reference fields that are not in the on same level / scope. What is the right way to create column totals in an SSRS 2005 Report Table?


I have one group in my report's table follwed by a footer in the table. I have 2 heades above my group.

Header1

Header2

Group1

Footer1 (this is where I'm trying to create my darn Column Grand Totals)