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

the best way to do these is to add your aggregates in your query. and drag and drop your filed in the footer. Mathieu Alexandre Cupryk www.omegalove.com