Group footer Sum

edited 9:04AM in FastReport 4.0
Hi

How to add calcul iside Sum formula?


I will like to add Gst or % in my group sum

the base formula is total:[(SUM(<frxDBDataset1."D_EXTENS">))] is good for colum total if I will add 10% at this total

my formula is [(SUM(<frxDBDataset1."D_EXTENS*1.1">))]

I have error inside my formula

Thank you for your help

Mario

Comments

  • gpigpi
    edited 9:04AM
    Use
    [SUM(<frxDBDataset1."D_EXTENS"> * 1.1)]
  • edited 9:04AM
    Thank a lot

    It possible to replace 1.1 with a variable

    ex: [(SUM(<frxDBDataset1."D_EXTENS">*TPS))]

    Thank again


    Mario



  • gpigpi
    edited 9:04AM
    [SUM(<frxDBDataset1."D_EXTENS"> * <TPS>)]
  • edited 9:04AM
    Thank you

    Just information


    How to config variable TPS in Delphi for calcul inside my report


    ex: in my prog


    ..


    var
    tps : real;

    begin

    tps:=0.05;

    ..........


    how to transfert in fastreport


    Thank you


    Mario





  • gpigpi
    edited 9:04AM
    frxReport1.Variables.Variables := tps;
  • edited 9:04AM
    Thank you

    I have error when I test

    error message : Sysmemo6.error in expression 'undeclared identifier : 'tps'

    my method is inside delphi XE2


    var
    variable: tfrxvariable;

    begin

    variable:= frxReport1.Variables.Insert(1);
    variable.name:='TPS';
    variable.Value:= 0.05;

    my formule inside frxreport1 is

    [(SUM(<frxDBDataset1."TOTAL_CARB">*tps))]


    thank you

    Mario


  • gpigpi
    edited 9:04AM
    Use in Delphi:

    frxReport1.Variables.Variables := tps;

    in report

    [SUM(<frxDBDataset1."TOTAL_CARB"> * <tps>)]
  • edited 9:04AM
    Hi

    Sorry I have the same problem with your anwser.

    frxReport1.Variables.Variables := tps;


    The variable tps is numeric(real) the value for tps is 0.05 for 5% tax


    I don't find my problem

    Thank you for your help


    Mario
  • edited 9:04AM
    Thank you


    I find my problem because I dont create my variable inside my frxreport


    My problem is Ok


    I very apreciate your help!!

    thank a lots

    Mario

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.