calulate where? price tva

edited 8:28PM in FastReport 4.0
Hello everybody i come from rave report and try FastReport.

i have a query with total price and price without taxe et i want total taxe, how calculate that, i don't find what write in my memoview

there is my two values
[Query."INVOICE_PRICE_HT"] [Query."INVOICE_PRICE_TOTAL"]
i have tried ([Query."INVOICE_PRICE_TOTAL"]-[Query."INVOICE_PRICE_HT"]) and lot others without success.

i'tried with code too:
var
TVA:Curency;
begin
frxReport.Variables[' ' + 'Others'] := Null;
TVA:=            Currency(FieldValues['INVOICE_PRICE_TOTAL']) - Currency(FieldValues['INVOICE_PRICE_HT']);
        frxReport.Variables['TVA']:=         TVA;

and in a memoview in report [TVA] say don't finded.

thanks for your help.

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 8:28PM
    ([Query."INVOICE_PRICE_TOTAL"]-[Query."INVOICE_PRICE_HT"])
    brackets in wrong place

    [(<Query."INVOICE_PRICE_TOTAL">-<Query."INVOICE_PRICE_HT">)]

    use the expression builder when building expressions it will get them right for you.
  • edited 8:28PM
    ok, thanks you. i understand better now how that work.

Leave a Comment