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 7:22AM
    Attach your report template (fr3)
  • edited 7:22AM
    gpi wrote: »
    Attach your report template (fr3)
  • edited 7:22AM
    Attach your report template (fr3)
    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 7:22AM
    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 7:22AM
    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 7:22AM
    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 7:22AM
    gpi wrote: »
    gpi 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?
    I've attached the output from the test.fr3 as TheFileYouSent.pdf
    and from my original fr3 file as OriginalFile.pdf
  • gpigpi
    edited 7:22AM
    Try to compile FRDemo project, load and prepare my test.fr3 report template in the FRDemo. Did you get same result?
  • edited 7:22AM
    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

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.