This is a migrated thread and some comments may be shown as answers.

Aggregate Sum

1 Answer 56 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Daniel Svensson
Top achievements
Rank 1
Daniel Svensson asked on 02 Oct 2009, 12:40 PM
Hi,

I'm using Enterprise Library to return a DataSet(from a stored procedure) that i use as my datasource to my report.
I have the report almost setup for me but i have trouble with one thing. The report has two columns

  • NoOfHours
  • DebitPerUnitHour

Example:
If one detail row has NoOfHours=8 and DebitPerUnitHour=$600, then i have a third column that calculates [=Fields.NoOfHours * Fields.DebitPerUnitHour].

Then I need in my footersection in my group to SUM the values from this third column. I know its simple to sum on an existing Field from satasource, but how to sum on an expression?

/Daniel

1 Answer, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 02 Oct 2009, 02:15 PM
Hello Daniel,

The built-in Sum() function would work on any expression and not only on database field. i.e.:

= Sum(Fields.NoOfHours * Fields.DebitPerUnitHour)

All the best,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Tags
General Discussions
Asked by
Daniel Svensson
Top achievements
Rank 1
Answers by
Steve
Telerik team
Share this question
or