How to create Total in the beginning of a report

Mehdi

Hello experts,
I'm trying to show the totals of the field "Amount" (Payment Header) of some records in the beginnig of the report.
I've tried to use CalcSum but i can't, the field "Amount" is already a Flowfield and i can't create a sumIndexField in the flowfield.
How can I do that?
Thanks!!

vijay_g

Required more information. attach your code what you have written?

kapamarou

Since it is a flowfield, then it uses a sumindex from another (probably line) table. Could your filters be applied the the lower level table and call that calcsums?

crisnicolas

then you'll have to iterate over the records and sum that field on a var....

But that will make your report to take longer to process, since it will have to iterate through all records first to sum that value, and then iterate again to show the records on the report....
It's easier to place the total at the bottom

matttrax

crisnicolas wrote:

then you'll have to iterate over the records and sum that field on a var....

No, that's the whole point of having the field as a SumIndex. You use the CALCSUMS function so you don't have to iterate through every record.

kapamarou wrote:

Since it is a flowfield, then it uses a sumindex from another (probably line) table. Could your filters be applied the the lower level table and call that calcsums?

I would follow this advice. Look at how the FlowField works and use a CALCSUMS on the field that it totals.

crisnicolas

matttrax wrote:

crisnicolas wrote:

then you'll have to iterate over the records and sum that field on a var....

No, that's the whole point of having the field as a SumIndex. You use the CALCSUMS function so you don't have to iterate through every record.

Yes, that's the point of having a SumIndex... but he said on the first post that he doesn't have a SumIndex...

Mehdi

Thanks guys for your help,
Actually, i've defined another Flowfield, and by using filter I can sum the total of all Report.