Daniel Svensson
Top achievements
Rank 1
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
0
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.
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.