Aggregates only in GroupFooter...
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 :
Does this mean that I need to calculate total in GF4 and save the value for later use (in GF1) ?
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 :
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) ?
Comments
* [mytable."myfield"] in a memo on DetailData1
* [sum(<mytable."myfield">,detaildata1,1)] on GF4, GF3 and GF2
Did I misunderstand you ?