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)
When I put this in my footer, it sums up that column just fine:
=Round(((Fields!FeeGoal_AZ.Value) / Fields!FeeSchedule.Value) * 100)
But when I try this on another field (just copy the formula from the group field and past into it's corresponding column footer field, it doesn't sum all columns:=IIf(Fields!New_Old_PDC.Value = False, Fields!PDC.Value, 0)
Here is a picture of my report to help: http://www.photopizzaz.biz/reportserver_grouping_problem.jpg

Grand Totals in Table