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