Article relates to
06 December, 2007
Last modified by
Add an average of calculated items in the footer section
Summaries can be added on the User Functions in the same way as on data source fields. For example, if your summary function is: public static double CalculateOrderPrice(double unitPrice, int amount)
return (unitPrice * amount * 1.20); //with VAT :-)
and your data field names are UnitPrice and Amount, you can set the following expression as the Value of a TextBox to calculate the Average of the results returned by the User Function: =AVG(CalculateOrderPrice(UnitPrice, Amount))
Attached you can find a little project containing a report that demonstrates the above scenario.