Creating reports and dashboards | Stimulsoft community forum

Posted: **Sat Sep 12, 2009 3:28 am**

Hi
I use the following code in Report event or in GroupHeaderBand event , but it dosen't work , generaly may I use aggerage functions in any part of report specialy in Report load or GroupHeaderbands(befor DataBand) ?

I use this sentence in begin render of report :
SumCreditPage = Totals.Sum(DataTable, (String.Compare(ACC040101.Date , FromDate) <= 0) ? ACC040101.Credit : 0);

Tanks
Mehrdad

Posted: **Mon Sep 14, 2009 7:05 am**

Hello Mehrdad,

If you want calculate totals based on groups you should use following code:

Code: Select all

SumCreditPage = Totals.Sum(YourGroupHeaderBand, (String.Compare(ACC040101.Date , FromDate) <= 0) ? ACC040101.Credit : 0);

Thank you.

Creating reports and dashboards | Stimulsoft community forum

using aggregate functions in Headerbands

using aggregate functions in Headerbands

using aggregate functions in Headerbands