Problem with the SUM Function

JVDSJVDS
edited 11:14AM in FastReport 2.xx VCL
I try to use in the memo this formula:
[Sum([tabeleTemp1."TEMP1"], DetailData1)+ Sum([tableTemp2."TEMP2"], DetailData2)]
And the result is always NULL
What's wrong?

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 11:14AM
    Hi
    Syntax
    [Sum([tabeleTemp1."TEMP1"], DetailData1)+ Sum([tableTemp2."TEMP2"], DetailData2)]

    add square brackets around each member of the expression and then around whole expression. you may have to use the ,1 param after the band name as well.

    Sum([tabeleTemp1."TEMP1"], DetailData1,1)] + [Sum([tableTemp2."TEMP2"], DetailData2,1)

    in some extreme cases you may have to store the value of one member of the expression in your own variable, at the correct footer, and use it in conjunction with the other member.
    ;)


  • JVDSJVDS
    edited 11:14AM
    Thank you very much for your answer, gordk

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.

Home • FastReport 2.xx VCLComment As ...

© Vanilla Keystone Theme 2024