say that you have a field that is how much it decreases:
local numbervar iDec := {table.field1};
local numbervar iOrig := {table.field2};
local datetimevar dPaid := {table.field3};
local stringvar crlf := CHRW(13) + CHRW(10);
shared stringvar sPrincipal := iOrig + crlf ;
shared stringvar sInterest := iDec + crlf;
shared stringvar sDate := totext(dPaid, "dd-MMM-yyyy);
local numbervar iCount := 0;
WHILE sPrincipal > 0 DO
(
iCount := iCount + 1;
iOrig := iOrig - iDec;
sPrincipal := sPrincipal + iOrig + crlf;
sInterest := sInterest + iDec + crlf;
sDate := sDate + totext(DATEADD("m", -1 * iCount, dPaid), "dd-MMM-yyyy) + crlf;
);
"" //hides all the calculations
OK, that is the formula that creates 3 strings...say it is in a band...doesn't matter which one, let's say a group footer for example.
I would place the formula in the group footer, then I would add a section to the group footer, so that the formula is in a, and what we want to display is in b. Suppress group footer a. Write 3 formulas to access the shared variables, like:
shared stringvar sDate
place the 3 formulas on the report and set the textbox to 'Can Grow'...it should display as the example.
Obviously, you will need to tweak the example to fit the actual interest calculation. If it is multiple fields, you can use the iCount as a flag to determine which field to use when.
The idea is give you a path to a solution.
HTH
IP Logged
