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

Robert.YostRobert.Yost
edited 5:11AM in FastReport VCL 5
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 5:11AM
    Attach your report template (fr3)
  • Robert.YostRobert.Yost
    edited 5:11AM
    gpi wrote: »
    Attach your report template (fr3)
  • Robert.YostRobert.Yost
    edited 5:11AM
    Robert.Yost wrote: »
    Robert.Yost wrote: »
    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

  • Robert.YostRobert.Yost
    edited 5:11AM
    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 5:11AM
    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 5:11AM
    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?
  • Robert.YostRobert.Yost
    edited 5:11AM
    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 5:11AM
    Try to compile FRDemo project, load and prepare my test.fr3 report template in the FRDemo. Did you get same result?
  • Robert.YostRobert.Yost
    edited 5:11AM
    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.

Home • FastReport VCL 5Comment As ...

© Vanilla Keystone Theme 2024