opening balance - closing balance

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

On my report I want to have an opening balance signifying all transactions
up to the month selected
and detailed transactions for the month selected
and then a closing blance.

I'm perpelexed how to do this Anyone knows how the banks do it with
statement formatting?

suggestions, ideas welcome.

Greg
 
But i don't want to see all other months. For example if user
selects Feb-2004 report should look like:

DESCRIPTION DATE IN OUT BALANCE
Opening Balance 31-01-2004 200

DescriptA 02-02-2004 20 220
DescriptB 05-02-2004 5 215
DescriptC 17-02-2004 9 224
DescriptD 19-02-2004 8 232
DescriptE 22-02-2004 20 252
DescriptF 26-02-2004 12 230

Closing Balance 29-02-2004 230

So maybe the opening balance represents many months of transactions.

Any Ideas.

Greg
 
Back
Top