Need to create complicated report in webfocus

[ecomajor]

Hi,
I have a reports. Lets say that it has 3 fields. and lets say I am pulling 3 rows of data. The 4 fields are begining balance, inflow, outflow and ending_balance. I want the sum values of the inflow and outflow fields and I only want to take the begining balance from the row that has the earlist date and I only want to take the ending balance from the row with the last date. I wanted to create a computed field but the problem is that I cant seem to force the report compiler to evaluate every row. can someone please email me help as I dont have internet access that often.

thanks

 

[craigiep]

ecomajor,

start by ensuring the data is in the correct order then use the FST and LST operators

eg

TABLE FILE X
PRINT *
BY DATE
ON TABLE HOLD
END

TABLE FILE HOLD
SUM FST.BEGINNING
INFLOW
OUTFLOW
LST.ENDING
END