Sum of total hours column

[surya murthy]

hi telerik team,

I'm using telerik reports for time sheet report,

in that report we have total hours column for particular task,

we need to display sum of the total hours column.

Employee Name
  Task-1     3.30
  Task-2     4.00
  Task-3     5.50
              --------------
                  13.20 hrs

please provide me sum calculation for sum of fields

Thanks in advance

[Peter]

Hi surya murthy,

In order to create your reports' totals you should use a Sum Aggregate Function in a Report Footer, Group Footer or Table's Outside Group row.

Greetings,
Peter
the Telerik team

[Malcolm]

Hi, I realize this thread is older but I have a related question. How would I go about only summing certain values? Using the example sent by surya murthy ;

Employee Name
  Task-1     3.30
  Task-2     4.00
  Task-3     5.50

How would I go about only summing the total for Task-1 and Task-3?

Thank you,

Malcolm Diaz

[Malcolm]

Ok. I actually found the answer in a different post. The long and short of it was knowing where to put the sum function.

Originally I was trying this;

= IIf(Fields.BonusTypeKey in (18,19),(sum(IsNull(Fields.BonusAmt_Wk1,0)) + sum(IsNull(Fields.BonusAmt_Wk2,0))), 0.00)

Unfortunately this was not getting me the results I sought, however this slight change in where I used the sum function made all the difference in the world;

= sum(IIf(Fields.BonusTypeKey in (18,19),(IsNull(Fields.BonusAmt_Wk1,0) + IsNull(Fields.BonusAmt_Wk2,0)), 0.00))