Creating column totals in SSRS 2005 Table

Last Post 05 Feb 2006 10:28 AM by dba123. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
dba123
New Member
New Member

--
05 Feb 2006 10:28 AM
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)Text


Acceptable Use Policy
---