Totals in Report

Hi,

I am struggling with adding Totals to my Report Form. I need Totals for Base Amount column, and for Other Amount Column.

I try to setup these Total values like this:

But on Report I am receiving this error:

So how can I add Totals to my Report Form?

Thanks.

Find more posts tagged with

Mongoose

Hello,

I think there's a batch mode settings in the collection when in design mode.. havent played with it though..

Can you try, on the event stformreportcompleted or stdobjectrefresh completed, call a formscript and then the code will be like

Dim TotalAmount As String = ThisForm.PrimaryIDOCollection.GetObjectAggregateValue(WSAggregateFunctions.SUM, "VatAmt", "BuilderPoNum", row)

Or you may need to loop in the entire collection.

The idea I'm thinking is do the computation or looping after ALL the data is loaded..

Regards,

Kaz

Ok, I can try this. But on which event I can do this counting? To be sure, that all data is loaded?

Hello,

Can you try an event like stformreportcompleted please

Regards,

Kaz

I can see only these events starting with stdform

Ha, I found solution in KB1941375

The proper event for calculation is

StdObjectSelectCurrentCompleted

And calculation must be done via loop thru whole collection. Aggregate functions will not work.

Great! Thats good news! Thanks Pavel