Aggregates only in GroupFooter...

thefreecat

Converting from FR2.54. I have a big report designed this way :

GH1 (GroupHeader1)
GH2
GH3
GH4
DetailData1
GF4 (GroupFooter4)
GF3
GF2
GF1

In GroupFooter1OnBeforePrint I tried :
total:=<sum(<mytable."myfield">, detaildata1)>;

But "total" is always a null value.

In the User's manual, I read :

wrote:

There is a general rule for all aggregate functions: a function can be counted only for the data-band and displayed only in the band’s footer (the following bands refer to the latter: footer, page footer, group footer, column footer, and report footer).

Does this mean that I need to calculate total in GF4 and save the value for later use (in GF1) ?

AlexTZ

Probably you get null because of another restriction of agrregates: it should be used in memo objects, then you can use it in the script.

thefreecat

I have :
* [mytable."myfield"] in a memo on DetailData1
* [sum(<mytable."myfield">,detaildata1,1)] on GF4, GF3 and GF2

Did I misunderstand you ?