SQL Server Performance Forum – Threads Archive

Creating Column Grand Totals in an SSRS 2005 Repor

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)

---

]]>