SQL Server Performance

Creating Column Grand Totals in an SSRS 2005 Repor

Discussion in 'SQL Server Reporting Services' started by dba123, Feb 5, 2006.

  1. dba123 New Member

    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)

Share This Page