Need help with field sums
I have been modding the program "Ant Movie Catalog" to use as a basic stock cataloguing tool. All is going well so far, and have been working on a print out report for order forms.
The report designer that is used is FreeReport 2.32, I have taken care of the design/layout I require for the report, and all that is left to do is add a simple box which multiplies the [Resolution] field by [Length] field and prints the sum. Since I know very little about coding I am having trouble implementing this... Could you help me out please?
The help file suggests using the sum() expression parser, and antp (the author of AMC) suggested putting this in the text field script option -
begin
tmp1 := IntToStr(StrToInt([length]) * StrToInt([resolution]));
end;
Neither of which have worked [img]style_emoticons/<#EMO_DIR#>/sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> This is all very new to me, so if you guys point me in the right direction that would be a huge help! Thanks, Dawson[/img]
The report designer that is used is FreeReport 2.32, I have taken care of the design/layout I require for the report, and all that is left to do is add a simple box which multiplies the [Resolution] field by [Length] field and prints the sum. Since I know very little about coding I am having trouble implementing this... Could you help me out please?
The help file suggests using the sum() expression parser, and antp (the author of AMC) suggested putting this in the text field script option -
begin
tmp1 := IntToStr(StrToInt([length]) * StrToInt([resolution]));
end;
Neither of which have worked [img]style_emoticons/<#EMO_DIR#>/sad.gif" style="vertical-align:middle" emoid=":(" border="0" alt="sad.gif" /> This is all very new to me, so if you guys point me in the right direction that would be a huge help! Thanks, Dawson[/img]
Comments
IIRC all you need in the memo is fieldname]*[fieldname
you only use the sum function when summing values of multiple records.
Just created a report summary object with the following code -
Total Order Cost - ??[SUM(<Totalcost>,MasterData1)]
don't try reading fr4 documentation for free report to many differences.
ill post a couple of old fr2.? help files in the free report news group for you later to day or early tomorrow.