Trying to create a year end report of account balances as at a certain date
Have created a main report of all members
have a sub report which finds for each member the last transaction on or before the target date. The SalesTrans BO contains an attribute CloseBal which is the account balance at the end of each transaction
All this works well, but now I'd like to get a summary total of all members' closing balance onto the main report - but SUM SalesTrans.closebal just shows 00.00 (SalesTrans being in the SubReport)
Any ideas?
