hi people... is to late but... HAPPY NEW YEAR... .
I'm create a little report for my tables, but i can´t show the results for different keywords, example.
for each table1 where table1_date_w = today
and table1.cash > 0,
first table2 where table2.id = table1.id
no-lock break by table2.instr.
if last-of (table2.instr) then do:
display
table2.id
table2.date_oper
table2.cust
table2.instr
table2.cash
total_csh.
end.
end.
I need show this result
id | date_oper | cust | instr | cash | total_csh |
---|---|---|---|---|---|
5 | 28/09/2012 | 123456 | A | 1,5000 | 1,500 |
8 | 28/09/2012 | 963852 | A | 3,0000 | 4,500 |
15 | 28/09/2012 | 123987 | B | 250 | 250 |
22 | 01/10/2012 | 456987 | B | 1,500 | 1,750 |
35 | 05/10/2012 | 123654 | C | 2,500 | 2,500 |
How I can show the results like the column 'total_csh' where the price is 0 and calculate when the instr change.
Can you help me???... pelase...
Have a look at the ACCUMULATE / ACCUM functions.