Hi
I am using the following code to calculate sum of zbetrag from another table.
This is working gut.
But I want to have the Sum of this column in the List page like Total in Aggregate coloumn.
Is that possible? Or is there better way to do this?
function ListOptions_Rendered() {
if ($this->Id->CurrentValue <> "") {
$zahlungen = ew_ExecuteScalar("SELECT SUM(zbetrag) FROM zahlungen WHERE zrechid='".$this->Id->CurrentValue."' Group By zrechid");
$this->ListOptions->Items["zahlungen"]->Body =number_format($zahlungen, 2, '.', '');
$this->ListOptions->Items["zahlungen"]->CssStyle="text-align:right; ";
}
}
thanks
mpol_ch