Grand Totals in Table

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


 




Answer this question

Grand Totals in Table

  • Grand Totals in Table