SUM Just prints [SUM(<frDsReport."Amount">,MasterData1)]

I am trying to add a SUM to my report.

I add the field:
[frDsReport."Amount"]


to the MasterData Band and it prints OK

In the GroupFooter (also tried Page Footer) I added:
[SUM(<frDsReport."Amount">,MasterData1)]

But instead of summing it up it prints:

[SUM(<frDsReport."Amount">,MasterData1)]

where the sum should be.

Comments

  • gpigpi
    edited 10:36AM
    Attach your report template (fr3)
  • edited 10:36AM
    gpi wrote: »
    Attach your report template (fr3)
  • edited 10:36AM
    Maybe the problem is that I click on the item and System Memo comes up.
    I click on Aggregate Value
    Fill in all field
    CLick OK

    But when I look at it again it has Text Selected and
    [SUM(<frDsReport."Amount">,MasterData1)]

    in the text field

  • edited 10:36AM
    It shows the total when I click the preview button in the designer, but when I run the report it show the text.
  • gpigpi
    edited 10:36AM
    wrote:
    But when I look at it again it has Text Selected and
    [SUM(<frDsReport."Amount">,MasterData1)]
    I don't see [SUM(<frDsReport."Amount">,MasterData1)] in the IncomeDetailed.fr3
    I've see SUM([frDsReport."Amount"])
    Try
    [SUM(<frDsReport."Amount">)]
    wrote:
    It shows the total when I click the preview button in the designer, but when I run the report it show the text.
    Create small demo project and attach it
  • gpigpi
    edited 10:36AM
    wrote:
    It shows the total when I click the preview button in the designer, but when I run the report it show the text.
    Try to run report from attach. What result did you get?
  • edited 10:36AM
    gpi wrote: »
    Try to run report from attach. What result did you get?
    I've attached the output from the test.fr3 as TheFileYouSent.pdf
    and from my original fr3 file as OriginalFile.pdf
  • gpigpi
    edited 10:36AM
    Try to compile FRDemo project, load and prepare my test.fr3 report template in the FRDemo. Did you get same result?
  • edited 10:36AM
    gpi wrote: »
    Try to compile FRDemo project, load and prepare my test.fr3 report template in the FRDemo. Did you get same result?

    It works when I create a test project. I will look at what could be different. If you have any ideas, please let me know.

Leave a Comment