Column Grand Totals

Hot Topic

Problem to connect to Reporting Services 2005 from Enterprise Managment Studio
XML timed out
Reporting Services Error
Stuck between "Failed to generate user instance" and "An attempt to attach...failed"
How to Reuse functions in script tasks ?
Foreach Loop Enumerator Question
Password problem
MFC/SQL Server 8 + ODBC problems
Discard Rows in a flat file
How I can make trigger to Add Row 4 to my data base??

SQL Server

IE Scripts and Printing Error
Custom aggregate function
Snapshotting AS Cube
Cannot connect to SYNDIOMSVR. InternalsVisibleTo declarations cannot have a version, culture, public key token, or processor arc
Incorrect syntax near '?'
List of All SSIS packages stored in MSDB
Problem with concurrent insert and update commands
PLEASE HELP, I am stuck
the mirrored server is always in the state of restoring only
simple spell checking algorithm

Column Grand Totals

Is there a slick way to add grand totals to my report so far, in my report table I have the following sections

TableHeader1

TableHeader2

Group1

Footer1

I added one of the same fields from my Group1 to Footer1....but it's not summing correctly. I have this in my footer right below one of my Group Fields:

=SUM(Round(((Fields!FeeGoal_AZ.Value) / Fields!FeeSchedule.Value) * 100))




Answer this question

Column Grand Totals

  • borba777

    totals are accurate...I just needed to add SUM() to my group row fields and then I saw the light...My grand total was acting fine, it was just my row items that weren't showing currect Sums. I assumed that since the SSRS 2005 report had a group, that it would sum up it's rows automatically but that's not the case, you still need to use SUM() around your fields in your group.

  • aahmad

    From the expression it looks like you are summing up percentage values Is this really what you want

    Maybe you are actually looking for the average percentage value
    E.g.
    =Avg(Fields!FeeGoal_AZ.Value / Fields!FeeSchedule.Value * 100)

    -- Robert



  • ctimko

    Rob, can you help me!! need your input since you're the only one who seems to have any knowledge on this. I am very desperate here! This can't be that hard:

    http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=235554&SiteID=1



  • farukh

    sorry, just ignore that one. Try this...this is actually numbers:

    =SUM(Fields!PostedAmount.Value)

    when I put that in my footer, it isn't summing my Group field above it in my Group1 correctly all the way down that colum...

  • Column Grand Totals
Answer this question