CODEWITHSUNDEEP
oracle11gdelphi-7fastreport
mizkyd
mizkyd

Reputation: 75

calculate db data in fastreport

In fast report 4, I have a memo with a database value inside. let's assume it is memo1 and inside is [frxDBDataset2."AWAL"]. then I have another memo --memo2 and inside is [frxDBDataset1."DEBET"]. for short it'll be:

memo1:=[frxDBDataset2."AWAL"]
memo2:=[frxDBDataset1."DEBET"]

Now, I wanted to calculate memo1 and sum of memo2, then show in in memo3. for short it'll be :

[frxDBDataset2."AWAL"]+sum of [frxDBDataset1."DEBET"]

how and where do I do this? thanks in advance!

Upvotes: 1

Views: 488

Answers (1)

gpi
gpi

Reputation: 544

Try to use

[<frxDBDataset2."AWAL"> + SUM(<frxDBDataset1."DEBET">, MasterData1)]

Upvotes: 1

Related Questions