I have a table with 4 fields, and thousands of records. using VFP 9 SP2
the table indexed on code
in the report designer, in the group header 1:code
I have this expression ..IIF(_PAGENO = 1,amount3 + amount2 - amount1, ' ')
the report is working very fine no problem.
My question is: I want to display the same value of the above expression, in the group Footer 1:code
although the cursor now on record 100 with same code different values of amounts.
Is this possible? Or is there a way to do it differently in the report?.