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 :
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) ?

Comments

  • edited 8:33AM
    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.
  • edited 8:33AM
    I have :
    * [mytable."myfield"] in a memo on DetailData1
    * [sum(<mytable."myfield">,detaildata1,1)] on GF4, GF3 and GF2

    Did I misunderstand you ?

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.