Column Grand Totals

Hot Topic

SSIS Connection Object and Expressions
Execute Stored Procedure via Execute SQL Task
I need a CONNECTION GURU to explain what is going on.
SQL DMO Support in SQL Server 2005...
DR for Crystal Enterprise and Business Objects
Installing feature Pack components with an Application
How to import data from Text file which contains header?
Scaling Model for Sales Force Automation
Report Model - int fields missing from model yet they are in Data View. How do i add a new field?
"Failed to create web application" error during installation of SQL 2k5b2

SQL Server

using table name stored in a scalar variable in stored procedure problem
Accessing SQL Mobile Databases in VB2005 - Pocket PCApp
Connecting to SQL server 2005 express in LAN Using C# express
Separate date and time datatypes - come on guys!
identity seed questions
Express Manager download for RTM version of SQLServer Express
SQL Server Agent Job Variables
"Prediction steps" has no effect for "Microsoft Time Series" algorithm
Error using Reporting services
Linked measure groups

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

  • poletnik

    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



  • annemarie

    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.

  • Kundan Singh

    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...

  • DMcNeil

    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



  • Column Grand Totals
Answer this question